Thread: Bar Graph with Double y-axis

I am tyring to make a graph that has 2 y-axis'. I know how to do this but the problem is once i make a 2nd y axis my chart changes to single columns. I need it to be a bar graph with 2 bars for each item on the x-axis for comparison reasons. I have attached an example of what i'm doing.

The first chart in the example is what i need it to look like but with a 2nd y axis. The second chart is what happens when i add a 2nd y axis.

You have to alter you data layout
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

It works the same way in 2007 as in 2003.