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.

Find more posts tagged with

Accepted answers

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.

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.