| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
Quote:
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a "fuel gauge" type graph (from 1-5) to show data | Charts and Charting in Excel | |||
| how can i get a "Column - Line on 2 axes" graph? | Charts and Charting in Excel | |||
| Can you make a "split" or broken y-axis on a graph in Excel? | Charts and Charting in Excel | |||
| How do I make a "0" appear on the Y-axis of my graph? | Excel Discussion (Misc queries) | |||
| how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) | |||
Linear Mode
