Charts with Groupings on the X-Axis

Dale Georg
edited 12/09/19 in Smartsheet Basics

I'm looking to create a chart which has multiple layers on the X-axis.  It doesn't seem possible to do with Smartsheet, but thought I'd throw the question out there to see if I was missing something.  To be clear, I've attached a screenshot from Excel that shows what I'm looking to do.  The top graph is what I want, where each item is also labeled with the group it is in.  The bottom graph shows what I have been able to achieve with Smartsheet - just the items without the groups.

The only workaround I can think of would be if I created another column in my data which concatenated the group name and the item name, and then use that column as the labels on my X-axis.

Screen Shot 2019-09-27 at 10.03.58 AM.png