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
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives