Dynamic pie chart labels

[mdazuk]

Hi

Wondering if you clever ppl can help me.

I have created PivotChart I have used a pie chart to display two bits of data. I have created a slicer that filters the pivot chart (this is into years). The problem I am having is that the internal Data labels withing the pie chart that shoes the percentage, keeps moving all over the place each time I filter the data.

What is the best way to fix this.

Thanks in advance.

 

[Fazza]

It sounds like the percentages should change as the data is filtered, and everything is perfect as is. I don't understand what you're wanting.

If you want to fix something, can you give an example of what you want to fix? Maybe if you take an image of the unfiltered results you can used that fixed image? if so, please google "Excel copy as picture".

 

[mdazuk]

Thanks for replying,
I have inserted a couple of images of different filter results, if i drag the data label back into the correct position they will move again when I filter again.

 

[Fazza]

Many thanks for those images. I understand the issue about labels moving (though I don't know which is the correct position, and which the wrong position). I'm unable to give a solution.

Pivot Chart Formatting Changes When Filtered - Peltier Tech

When you apply a filter or slicer to a PivotChart the custom formatting can change with each change in the filter. Here's what you can do about it.

peltiertech.com

suggests some workarounds.

Any solution may vary with the Excel version - so it may help others to know what version you're working in.

All the best.