Force a new column in a Stacked Column Chart?

[Blair]

I have need to use the "stacked column chart".  But my data doesn't lend itself to have a natural break point to start a new column on its own (see screenshot 1).  So, I had to create 10 seperate stacked column charts to get the desired effect (screenshot 2).  That gets pretty big and harder to understand what's going on in the graphs.  Is it possible to force a new column in a graph manually for screeenshot 1?

Below are multiple seperate Stacked Column Graphs.  Each with their 2 associated data points.  Each graphs show Full time and Part time by a given ethnicity.  I need to have this be one graph, but a new column manually forced at each change in ethnicity.  Becasue the data is gathered on institutions (and not a person), each instution has every ethnicity, so there's no natural break point for the chart to start a new column.  So, I want to do this manually, but in one easier to read chart.  Thanks!

[Greg_Deckler · Accepted solution]

So, there is something in your data by which you can categorize these as ethnicity, try putting that on your Axis. Witout understanding your data model, I can't tell you exactly how to do that so if you can give me an idea of your data structure, can probably find a way to make that happen.

[Blair]

Yeah, my data structure was coming from a "summarized" source and the structure wasn't going to cut it for chart purposes.  I went with a raw data source and made sure the axis had a value in it and evrything works fine.  Graphs looking as expected now.