How to get Groups to appear as buckets on a chart?

Hi everyone,

I currently have a report that is grouped as shown. However, when I create a chart on the dashboard the columns are not separated properly into groups. I am wondering if there is a way to create buckets and create a graph similar to the one I created in Excel.

Smartsheet report:

Screen Shot 2022-11-17 at 4.03.25 PM.png

Chart in Smartsheet:

Screen Shot 2022-11-17 at 3.57.49 PM.png

Chart in Excel:

Screen Shot 2022-11-17 at 3.59.35 PM.png

Thanks everyone

Answers