2nd Y axis on a Bar Graph

[slaidlaw]

I am trying to add a second y axis to an excel column graph. I would like to display one data series using a different scale so the data is displayed more effectively.

I'm sure this is really easy, but I can't figure out how to do it

Thanks for your help...

 

[abiram01]

Do you need to do this using VBA code or directly from chart options?

 

[PaddyD]

"I'm sure this is really easy..."

On the assumption that 'really easy' precludes using a vba solution when the functionality is provided as standard...

select the series, right click, select format series, select the axis tab, click secondary

 

[Andy Pope]

Whether you end up using a manual or vba method to set a series to the secondary axis you will need to alter your data layout inorder to avoid the columns obscuring each other.

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html