Chart with 2 X Axis

brendanolear

Active Member
Joined
Apr 26, 2008
Messages
366
Can anyone advise how I create a bar chart with 2 x-axis - looking to have Sales Values on LHS of graph and Sales Volumes on RHS.

Thank you.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Assuming that you really mean two Y (vertical) axes, right click the series that you want to have the axis on the right and select Format Data Series. On the Axis tab, tick Secondary axis.
 
Upvote 0
Have added secondary axis but ideally I only wish to show 1 column per measure i.e an axis that is scaled across both Values and volumes. On adding the volume measures I have an additional column that does not match the original values column - I would have thought that both axis would be scaled to each other ---- if that makes sense!
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,949
Members
448,534
Latest member
benefuexx

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
Back
Top