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.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,968
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
 

Forum statistics

Threads
1,141,029
Messages
5,703,826
Members
421,318
Latest member
cg_cartoonexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top