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

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,118,302
Messages
5,571,432
Members
412,392
Latest member
Carterland
Top