Chart with 2 X Axis

[brendanolear]

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.

 

[VoG]

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.

 

[brendanolear]

Thanks VoG II - and yes I did mean Y axis

 

[brendanolear]

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!

 

[VoG]

I don't really follow but perhaps this will help http://support.microsoft.com/kb/214011

Alternatively see http://www.peltiertech.com/Excel/Charts/ChartIndex.html