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

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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?
 
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.
 
BSc said:
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"
<><><><><><><><><><><>


:
-
Click to expand...

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
+-------------------------------------------------------------------
 
Back
Top