Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create more than two Y axis in a chart?
I need to assign data series to 3 or more y axis. I can only see upto
secondary axis option. Is there a way I can add parallel lines that show more than 2 y axis scales. Many thanks |
#2
|
|||
|
|||
you can only do two y axis on one chart, but
you can overlay charts and play with positioning and sizes to get what you want. (this is awkward) or Scale your data so that they all fit within a given range, add a text box or picture with the correct ranges that look like they are part of the Y axis labels "Anuj" wrote: I need to assign data series to 3 or more y axis. I can only see upto secondary axis option. Is there a way I can add parallel lines that show more than 2 y axis scales. Many thanks |
#3
|
|||
|
|||
You can add any number of pseudo axes using this technique:
http://peltiertech.com/Excel/Charts/TertiaryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anuj wrote: I need to assign data series to 3 or more y axis. I can only see upto secondary axis option. Is there a way I can add parallel lines that show more than 2 y axis scales. Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
How do I create a Line-Column on 2 Axis chart that allows more... | Charts and Charting in Excel |