bar charts with two axes

[sclapham]

I am trying to draw a bar chart with two bars and two different axes. The chart defaults to a stacked bar format which is not what I want. I can do a column chart with a line then save it as a picture and turn it ion its side but that is not a very elegant way of presenting the data, and I was hoping that someone had a fix. Can anybody please help?

[Herbds7]

Excel 2010, Table, PivotTable, PivotChart
Bar chart with 2 non-overlapping series.
http://58918aa17d4002474361-7ac2b7ee...05_21_13b.xlsx
If you get *.zip, don't unzip, just rename *.xlsx

[JoePublic]

When you select the chart type there are several different options for the bar - including clustered rather than stacked. It sounds like you want clustered.