Legend Totals
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?
Comments
-
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.
-
What a creative solution! Thanks for sharing that Paul!!!!
-
Thank you so much @Paul
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives