Help!

Multiple Y axis on a line chart

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Charting RSS
Next:  Creating a Chart in a C# Application...  
Author Message
Roe
External


Since: Aug 29, 2006
Posts: 2



PostPosted: Tue Aug 29, 2006 5:59 pm    Post subject: Multiple Y axis on a line chart
Archived from groups: microsoft>public>excel>charting (more info?)

Is it possible to have multiple Y axis on a chart? I see that you can
have a primary and a secondary axis, however what if you need to have
many - say 5 or 6? (Perhaps the measurement units are a different
format).

Thank you.
Back to top
Jon Peltier
External


Since: Mar 19, 2004
Posts: 2010



PostPosted: Wed Aug 30, 2006 3:17 am    Post subject: Re: Multiple Y axis on a line chart [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You can fake this, although by the time you're up to 5 or 6 axes, there's
not much room for data. Here's my example of a tertiary axis:

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

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


"Roe" wrote in message

> Is it possible to have multiple Y axis on a chart? I see that you can
> have a primary and a secondary axis, however what if you need to have
> many - say 5 or 6? (Perhaps the measurement units are a different
> format).
>
> Thank you.
>
Back to top
Jon Peltier
External


Since: Mar 19, 2004
Posts: 2010



PostPosted: Wed Aug 30, 2006 3:18 am    Post subject: Re: Multiple Y axis on a line chart [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You could make a panel chart, like these examples:

http://peltiertech.com/Excel/Charts/StackedCharts.html
http://processtrends.com/toc_panel_charts.htm

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


"Roe" wrote in message

> Is it possible to have multiple Y axis on a chart? I see that you can
> have a primary and a secondary axis, however what if you need to have
> many - say 5 or 6? (Perhaps the measurement units are a different
> format).
>
> Thank you.
>
Back to top
inquiry
External


Since: Mar 23, 2006
Posts: 5



PostPosted: Wed Aug 30, 2006 10:14 pm    Post subject: Re: Multiple Y axis on a line chart [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Yes. For multiple Y axis (3, 4, 5, 6 ... axes) Excel charts, try
EZplot or Multy_Y from Office Expander (www.OfficeExpander.com).



Roe wrote:
> Is it possible to have multiple Y axis on a chart? I see that you can
> have a primary and a secondary axis, however what if you need to have
> many - say 5 or 6? (Perhaps the measurement units are a different
> format).
>
> Thank you.
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Charting All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum