| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple 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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Multiple Y axis on a line chart
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 oups.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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Multiple Y axis on a line chart
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 oups.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. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Multiple Y axis on a line chart
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I link timeline labels to a line chart? | Charts and Charting in Excel | |||
| x axis labels/scale move to middle of chart w/neg & pos line cht | Excel Worksheet Functions | |||
| Line chart for churn rates of many items over time | Charts and Charting in Excel | |||
| How do I change x axis values in a line chart? | Charts and Charting in Excel | |||
| Problems with X Axis for a Line Chart | Charts and Charting in Excel | |||
Linear Mode
