stacked bar chart with two axis for a single set of data?

[Luca591]

I have this set of data. Its got two rows (1 and 2) Its 12 columns long. so its a 2x12 matrix.

I have the bar chart currently setup where columns each row entry in each column is stacked on top of eachother with two different colors. This goes across the table like that. However, I want to add a secondary axis for columns C through L (3-12). The reason being that the data in columns A and B are of a different magnitude than the data in columns C-L (3-12). Ive tried making multiple data sets and adding them to the same plot with one data set on the primary axis and the other data set on a secondary axis but I cant get this to work. I think it has to do with the horizontal axis labels but no matter what I try I cant get it to work.

Any ideas?

 

[Steve=True]

Hi Luca591,

It sounds like you are trying to get a stacked column chart like this?

Here is how you can set up your data. Then move rows 4 and 5 to the second axis. Then Switch Rows/Columns.

Also, here is a detailed tutorial if you need to keep your Row1's and Row 2's together.
how-to-make-an-excel-clustered-stacked-column-chart-with-different-colors-by-stack


Let me know what you think.

Steve=True