Show true % of Grand Total as label on pivot bar chart

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!
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,114,278
Messages
5,546,939
Members
410,764
Latest member
Dedeke
Top