creating a secondary axis from stock chart

[Tiffany]

Hi,

i have created a stock chart which have open, high, low and close points. I
want to include a secondary Y axis to chart the volume. May i know how to do
it?

Thank you

 

[Bernard Liengme]

Assuming you have at least two data series: right click on one and open the
Format Series command, you should have no trouble finding the feature to add
secondary axis.

For classical Excel:
http://office.microsoft.com/en-us/excel/HP052016901033.aspx
For Excel 2007: http://www.techonthenet.com/excel/charts/2_y_axes.php

If you still have a problem please tell what version of Excel you are using