How do I make a graph with 2 "Y-Axes" at different scale?

[Kevin]

I wish to make a Graph, with 0 to 10,000 pounds on the "Left Y-Scale" and 0
to 100% on the "Right Hand Y-Scale" Can this be done in Excel 2003? If so,
how is it done?

 

[BSc Chem Eng Rick]

It is definitely possible.

Click on your chart and select the Data Series you wish to have on a
secondary axis. Right click and "Format Series". On tha Axis tab, select
secondary axis and it will show up on your chart.

 

[bala_vb]

It is definitely possible.

Click on your chart and select the Data Series you wish to have on a
secondary axis. Right click and "Format Series". On tha Axis tab
select
secondary axis and it will show up on your chart.
--
If this helps, please click "Yes"
<><><><><><><><><><><>


:
-

Yes, possible.

You can play with secondary axes and can have % values of data.

Right click on chart and choose secondary axes
->you can play with axes.

I have attached sample spread with graph.

Thanks
Bal

+-------------------------------------------------------------------
|Filename: Graph.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=137
+-------------------------------------------------------------------