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.
