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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!