Bar Graphs

scuba_elmer

New Member
Joined
Feb 10, 2005
Messages
5
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.
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,922
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,956
Messages
5,545,177
Members
410,668
Latest member
Gaexel
Top