 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / August 2006Multiple Y axis on a line chart
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. 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 _______ > 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. 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 _______ > 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. Yes. For multiple Y axis (3, 4, 5, 6 ... axes) Excel charts, try EZplot or Multy_Y from Office Expander (www.OfficeExpander.com). > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.