Forum Discussion
Helper IIShow aggregated values in piechart legend
Microsoft Employee
In a chart, the legend is only to display the series/ categories, it’s not possible to show aggregated values dynamically in pie chart legend. For your requirement, you can turn off the legend for your pie chart, and use a table visual beside the pie chart, and display the categories and the corresponding aggregated values dynamically on that table which sliced by other field.
Regards
This is one of the most basic functions that make pie charts even relatively useful. Not having a legend, showing the value of the slice represented, seems to make the chart useless from a functional rather than purely artistic/visual point of view. This has also ben removed from Excel pie charts as far as I can tell, but they at least allow showing the value inside each actual slice (just not in the legend). Why is this no longer a supported feature? That's like not allowing us to see the specific height of a bar in a bar chart. I can see one slice is smaller/larger than the other, just bot to what actual extent. A question almost always asked by almost anyone looking at a pie chart that actually cares about what it represents!
Creating a "fake legend" by showing a grid with the values divorces it from the legend by not allowing it to show the other typical function of the legend, the color of the slice that label represents.
I sincerely wish Microsoft valued the usefulness of its chart types, rather than simply ticking off a "requested feature" list as a bare-bones object.
Exactly what I think! it's ridiculous, because when my value is so small that the portion of the color in the pie chart is not even viewable, how can they
know the value? and my only hope was that the legend would display the value! but no! and I don't know how to solve this problem 😕
See my image. How many acres of oats? WHO KNOWS!
