![]() 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 |