Bar Graphs

[scuba_elmer]

I was wondering if there is way to show a bar graph with two different axes? That is plot two different series with their own axis.

In the graphing option I see that this is possible to use a line graph with 2 axes...I could use a line graph but a bar graph would be easier for the audience to understand.

 

[Jon Peltier]

Forget about the built in types, they are too restrictive and inflexible. In general it's better to make your own chart, starting with all series as one type on the primary axis, then changing the types of each series by selecting it and using Chart menu > Chart Type, then assigning an axiss by double clicking and picking Primary or Secondary on the Axis tab of the Format Seriess dialog.

Column charts are trickier, though, because the secondary series will want to plot in front of, not next to, the primary series. I've posted a workable protocol for colun charts on two axes here:

http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html