How to display 2 data labels in a bar chart

Peter Hui

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.

Paul Newcome

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.

Paul Newcome

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.

Peter Hui

Thank you for getting back to me on my question, Paul

Paul Newcome

Happy to help. 👍️