Stacked graph next to a column graph

[erniepoe]

Hi all,

I have four rows of data (and 3 columns, indicating 2013-2015 yearly data). The first three rows I would like to have a stacked graph, showing the contributions of each data point towards the total of the 3. The 4th row I would like to have as its own column graph, next to the stacked graph of the first three rows.

I've played around with secondary axes, but just cant seem to get it right. Anybody have any tips?

Thanks!

 

[pgc01]

Hi

Jon Peltier has an article about this type of chart here:

Clustered and Stacked Column and Bar Charts - Peltier Tech Blog