Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Charts - Multiple Y-Axis

I know how to set up a scatter chart with two Y-axis....

Is there some way to set it up with three or more, preferably on the left
side of the page???
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Charts - Multiple Y-Axis

You can fake it, and it will add more clutter than the extra axes will clear
up, but here's a tutorial:

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

A better option is to make a panel chart, with each series in a separate
panel with its own axis:

http://peltiertech.com/Excel/Charts/StackedCharts.html
http://peltiertech.com/Excel/Comment...DayOfYear.html

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


"Condogod" wrote in message
...
I know how to set up a scatter chart with two Y-axis....

Is there some way to set it up with three or more, preferably on the left
side of the page???



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Charts - Multiple Y-Axis

On Mar 7, 2:16 am, Condogod
wrote:
I know how to set up a scatter chart with twoY-axis....

Is there some way to set it up with three or more, preferably on the left
side of the page???



To create three of more axes on the left of a chart, try Multy_Y for
Excel at www.OfficeExpander.com. There is a free demo version too.
For advanced multiple Y plots, try EZplot (which also has a demo
version).

Cheers.

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
custom chart - variable axis - multiple charts PJ Charts and Charting in Excel 1 February 2nd 07 03:07 PM
Grouping axis scale multiple charts Ozz Charts and Charting in Excel 1 July 26th 06 07:45 PM
Auto Display of X and Y axis values for multiple charts in WKBK Barb Reinhardt Charts and Charting in Excel 0 January 11th 06 02:46 PM
How do I plot multiple x-axis series in excel charts bdorr Charts and Charting in Excel 2 November 23rd 05 02:21 PM
Hiding Values Below Z Axis Minimum Value on Axis Charts TryingToExcel Charts and Charting in Excel 1 February 18th 05 03:55 AM


All times are GMT +1. The time now is 09:24 AM.

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

About Us

"It's about Microsoft Excel"