How to display 2 data labels in a bar chart
Hello everyone!
Good day.
I'd like to ask for your help in a task I'm trying to accomplish.
I'm trying to build a bar chart in a dashboard that will show the total amount collected by each team per year and also the number of collections they had. To this end, I have 2 sheets: Sheet 1 contains the raw data - all the entries per team for each year; Sheet 2 contains the total value for each team per year.
I was able to create a bar chart off of Sheet 2 showing the total value with the labels for the sum, but I don't know how to incorporate the number of entries (count) per team. Below is a screenshot of how I want the chart to look like.
Hope you could help me with this task.
Thank you.
Best Answer
-
That is not currently possible in Smartsheet although it would be a great feature. Feel free to Submit a Product Enhancement Request when you are able.
In the meantime, you would need to use either a separate graph of some metrics widgets to show the data.
Answers
-
That is not currently possible in Smartsheet although it would be a great feature. Feel free to Submit a Product Enhancement Request when you are able.
In the meantime, you would need to use either a separate graph of some metrics widgets to show the data.
-
Thank you for getting back to me on my question, Paul
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!