Hello,
I have a Pivot Chart that I am using but I would like to change the source data if possible. My pivot table is showing 2 value fields. 1 is a sum and the other is percentage. It makes my chart too messy to show both of these. I still want to keep the data in my pivot table but I'd like my chart to only show the sum.
Is this possible? If not is there a way to hide that on my chart?
Don't think it's possible to hide one of these totals in the Pivot Chart and keep it displayed in the Pivot Table (and otherwise I would like to learn that also here from somebody who knows how to do this!).
There is a workaround though.
Select in the Chart the column which you want to hide. Give that 'no fill' and 'no border'. You don't see it anymore after applying.
Only thing is that the axes maybe must be re-arranged because the higher values of the totals are not visable anymore but the ax still displays it.
Is this is something for you and this case?
I'm still hoping we can find an answer to the main question though. It would be useful in the future.
This work around is actually really helpful to get the desired look that I need on my chart. Thank You!!
One slight improvement is to set the % data series to be 100% overlap to keep the column alignment centred.
