I've tried the same thing with the pivot table first all expanded-no help. How do I make the chart smart enough to ignore collapsing/expanding of the pivot table rows?Įxperimenting with various fixes, I've tried copying/pasting the individual "top-level" data rows I want charted into the chart while the pivot table is all collapsed-doesn't help. As soon as I expand one or all of the pivot table row triangles (to see hidden rows), the range for the source data used by the chart gets thrown off. ![]() Everything works fine with my chart if I keep the pivot table closed/collapsed. I've successfully created a regular chart based off the data in a pivot table (which summarizes information in a backend table). ![]() I'm on Excel:Mac 2011 which still has no pivot charts (as far as I've heard).
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |