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.
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks