Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
three y axes
I have a chart with two y axes, one on each side, and a single x axis. Is it
possible to construct a chart with three y axes, e.g., units and dollar value on the left and percent on the right. Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
three y axes
Hi,
Yes if you build your own chart axes. Have a read on Jon's page on the subject http://peltiertech.com/Excel/Charts/TertiaryAxis.html Cheers Andy Kevin wrote: I have a chart with two y axes, one on each side, and a single x axis. Is it possible to construct a chart with three y axes, e.g., units and dollar value on the left and percent on the right. Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
three y axes
An easier to interpret option actually separates the data into separate
panels of the chart. This preserves the horizontal alignment of the series but removes the incorrect impression that the series somehow interact with each other (which is merely a consequence of how their individual axis scales were defined). http://peltiertech.com/Excel/ChartsH...venScales.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Andy Pope" wrote in message ... Hi, Yes if you build your own chart axes. Have a read on Jon's page on the subject http://peltiertech.com/Excel/Charts/TertiaryAxis.html Cheers Andy Kevin wrote: I have a chart with two y axes, one on each side, and a single x axis. Is it possible to construct a chart with three y axes, e.g., units and dollar value on the left and percent on the right. Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
X and Y axes | Charts and Charting in Excel | |||
Adjusting the y axes on 2-axes line graphs | Charts and Charting in Excel | |||
Show 'incomplete' axes & show ticks but NOT axes? | Charts and Charting in Excel | |||
3 of 4 Y axes | Charts and Charting in Excel | |||
Y Axes | Charts and Charting in Excel |