View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default creating a secondary axis from stock chart

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/ex...016901033.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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Tiffany" wrote in message
...
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