The data I have has two criteria, Partial or Full. I have the count of how many are Partial or Full and in the pivot table I change it to show as a percentage of the total. What I want to do is to toggle the PivotChart between percentage and count (with in the same bar graph).
The way I would do this is to create the pivot table to show both count and percent. Then overlay the results with a named dynamic range. Have the range for the display point to either the count or percent columns and then build the chart off the named dynamic ranges. If you can provide a sample workbook, I can show you how to do this.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks