I have a chart that I need to know if I can stack data using multiple data points. For example, see chart attached, I would like keep the axis categories the same, but would like to stack like columns for example: under 2CV CVICU I want to stack # of Core Staff with # of Core Staff - SB/LC and then in the next column it would be # Ext Travelers and # Ext SB/LC stack and so forth. See graph below. Not sure if it can be done this way or not.

Thank you - Lynda

Attached Images

Screenshot 2023-06-29 153809.jpg (97.2 KB, 8 views)

This would very likely done with a re-arrangement of chat source data; you would have a stacked columns throughout, but some of those stacked columns would comprise only a single value.
We really need to see a workbok with this in it. Pictures are hard work to deal with.