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

Options

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:

Chart in Smartsheet:

Chart in Excel:

Thanks everyone

Answers