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
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
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
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
I want to add 2 different scales in the secondary axis in the column chart. How to add. Please find the image.
https://www.highcharts.com/demo/combo-multi-axes
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks