| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dual Y Axis in Line Plots
How can i plot line graphs having dual Y axis at two ends? The two Y axis
have to be of different scales in the same plot. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dual Y Axis in Line Plots
amitsaurav wrote:
How can i plot line graphs having dual Y axis at two ends? The two Y axis have to be of different scales in the same plot. If you've set up to plot two lines, using the XY plot format, then: 1) Right click on one of the lines to highlight it, 2) Click on "Format Data Series" 3) Select the "Axis" tab 4) Click on the "Secondary axis" radio button Bill |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dual Y Axis in Line Plots
Thank You Mr Martin. Your reply helped me solve my problem.
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dual Y Axis in Line Plots
And mine too! Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dual Y Axis in Line Plots
How does this work in Excel 2007?
"Bill Martin" wrote: amitsaurav wrote: How can i plot line graphs having dual Y axis at two ends? The two Y axis have to be of different scales in the same plot. If you've set up to plot two lines, using the XY plot format, then: 1) Right click on one of the lines to highlight it, 2) Click on "Format Data Series" 3) Select the "Axis" tab 4) Click on the "Secondary axis" radio button Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel gives me line plots - I want scatter plots | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
| make line in chart start at y axis | Charts and Charting in Excel | |||
| overlaying xy plots on same axis | Charts and Charting in Excel | |||
| Plot a line? Set dymanic axis Max min | Charts and Charting in Excel | |||
Linear Mode
