Prev: Highlight on Date Problem
Next: Deleted file
From: Kevin on 3 May 2010 20:23
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?
From: BSc Chem Eng Rick on 4 May 2010 02:20
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"
<><><><><><><><><><><>


"Kevin" wrote:

> 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?
From: bala_vb on 4 May 2010 03:13

BSc Chem Eng Rick;950891 Wrote:
> 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"
> <><><><><><><><><><><>
>
>
> "Kevin" wrote:
> -
> > 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?-

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
Bala


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



--
bala_vb
 | 
Pages: 1
Prev: Highlight on Date Problem
Next: Deleted file