ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make a graph with 2 "Y-Axes" at different scale? (https://www.excelbanter.com/excel-discussion-misc-queries/262979-how-do-i-make-graph-2-y-axes-different-scale.html)

Kevin

How do I make a graph with 2 "Y-Axes" at different scale?
 
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

How do I make a graph with 2 "Y-Axes" at different scale?
 
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?


bala_vb

1 Attachment(s)
Quote:

Originally Posted by BSc Chem Eng Rick (Post 950891)
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


All times are GMT +1. The time now is 03:20 PM.

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