#1   Report Post  
Kelly McFaul
 
Posts: n/a
Default 3 of 4 Y axes

I have a chart that has a Y axis on the left and on the right side of the
chart. Is there any way to have 2 Y axes on the left and 2 on the right? I
would like to be able to compare 4 sets of data at the same time and the
range of values might be much different.
Thanks in advance,
Kelly


  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Kelly -

You can extend this technique to a quaternary axis:

http://peltiertech.com/Excel/Charts/TertiaryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Kelly McFaul wrote:

I have a chart that has a Y axis on the left and on the right side of the
chart. Is there any way to have 2 Y axes on the left and 2 on the right? I
would like to be able to compare 4 sets of data at the same time and the
range of values might be much different.
Thanks in advance,
Kelly


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I plot an XY (scatter) graph with two Y axes? PeterAtLufbra Charts and Charting in Excel 2 April 4th 23 10:44 AM
Y Axes Tony Charts and Charting in Excel 6 June 9th 05 06:15 PM
Scatter charts -- can I lock in a 1:1 aspect ratio for axes? Charts and Charting in Excel 2 May 31st 05 08:56 PM
How do I create a dual axes column chart in Excel Alok Charts and Charting in Excel 1 May 17th 05 06:11 PM
Locking gridlines to be square - axes to same scale ? John Mansfield Charts and Charting in Excel 0 April 7th 05 03:17 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"