Add secondary axis without stacking columns

**swaintwin** · 02-25-2009, 09:07 AM

I've tried a search and seen this question several times, but no successful answers. Does anyone know how I can add a secondary y-axis and not have the columns in my bar graph stack? I have a 2X2 data set that results in a total of 4 bars.

**Andy Pope** · 02-25-2009, 10:03 AM

This may help.
http://peltiertech.com/WordPress/clu...column-charts/

You need to change your data layout to stop the columns over lapping when using secondary axis.

**swaintwin** · 02-25-2009, 11:26 AM

can't seem to get it to work with only 2 non-overlapping columns desired.

**Andy Pope** · 02-25-2009, 11:36 AM

see attached.

**mickomack** · 04-20-2010, 05:58 PM

Hi,

Could anyone help me modift 673273.xls to display 8 columns in each category please i.e. 4 lavendar, 4 purple in the order lavendar, purple, lavendar, purple etc. It would be greatly appreciated.

Many Thanks!

Michael