grouping data in a bar chart

Chris Dimas

Hello! I have a similar request to Nannette Huber's from a year ago. Not sure if there is an upgrade to the tool that would accommodate for this. I transferred a simple project budget template from Excel to Smartsheet with the following columns:

1. Name of Project
2. Name of team
3. Name of activity
4. Name of resource
5. Four columns, one each for the 4 quarters of the year and the dollar amount (so each line has 4 dollar amounts)

When i create the dashboard for this sheet, using a simple bar chart, i get multiple bars for the same teams, whereas i am trying to show the summary per team (see attached). Is this possible?

Smarthseet dashboard example.PNG

Thank you

Paul Newcome

@Chris Dimas You would need to create a row report, group by the team, and then use the report summary fields to get your totals on the grouped lines. Referencing the report in your chart widget should get you what you are looking for.