| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to add another y-axis range into chart?
Does anyone have any suggestions on how to add one scale on right y-axis and
one scale on left y-axis? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to add another y-axis range into chart?
Hi,
In order to have 2 y-axis you require a minimum of 2 data series. Select the second data series and via the Format dialog set the series to the Secondary axis. This explains how to enable the secondary y axis when only 1 series is required. http://www.andypope.info/tips/tip005.htm You can not use the 3d styles if you want dual axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Eric" wrote in message ... Does anyone have any suggestions on how to add one scale on right y-axis and one scale on left y-axis? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding second data point on primary axis of two axis chart | Charts and Charting in Excel | |||
| Line chart with date range as X axis. | Charts and Charting in Excel | |||
| How to manually switch data from x axis to y axis in line chart? | Charts and Charting in Excel | |||
| TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Hybrid Mode
