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?

Find more posts tagged with

Solution Center

Product Development

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto