ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   creating a secondary axis from stock chart (https://www.excelbanter.com/charts-charting-excel/236344-creating-secondary-axis-stock-chart.html)

Tiffany

creating a secondary axis from stock chart
 
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[_3_]

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





All times are GMT +1. The time now is 08:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com