Legend Totals

Sherri Anderson

On the dashboard when I add a chart I would like the ability to include a total next to the legend item.  For example, if I am doing a pie chart, in addition to seeing the total items represented by that color in the pie chart, I would also like to see the total items next to that heading in the legend itself for quick reference.  Is this possible?

 

Paul Newcome

Yes. It is very possible. The legend labels would be in the Primary Column. Your count would be in a separate column.

 

In your Primary Column, you would use something like this:

 

="Legend Label: " + [Count Column Name]@row

.

See attached screenshots. I also changed some of the counts in the metrics sheet to ensure that it wouldn't break if the counts changed which would change the legend labels, and it worked just fine.

Mike Wilday

What a creative solution! Thanks for sharing that Paul!!!! 

Sherri Anderson

Thank you so much @Paul