STEVEMILLS04
Board Regular
- Joined
- Oct 8, 2009
- Messages
- 113
I am using Power Pivot in Excel Office 365 and created a bar chart that currently shows the count as the label. I would like to show the label as a percent. The problem is I have the chart filtered to show only the top 8 items by count and when I convert the label to a percent of total, it is only a percentage of the filtered values, not the true grand total of all values. I understand the logic of why pivot tables/charts do this, but is there a way to show the % of all items, even if filtered out? Thanks for any help!