2 bars, 2 axis??

[Luke]

I'm trying to create a graph which shows load factor (one bar) and yield (one
bar)for the month, then next to this the same data for the next month and so
on.

I can create the graph and assign each of the bars to the primary or
secondary axis. However this causes one of the bars to sit on top of the
other, I want them to sit side by side.

Any idea's please?

 

[Andy Pope]

Hi Luke,

For a 2 series column chart with a series on each y axis try Jon's example.
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

Cheers
Andy