Multiple Y axis values

[Flashoflight]

I have a number of data sets (vertical bars) in my graph. I would like to
display various Y axis values on the right or left side to indicate the value
of the vertical bar. It appears that I can only have (2) Y axis values
displayed. Is there a way to show more?

 

[inquiry]

I have a number of data sets (vertical bars) in my graph.  I would like to
display variousYaxis values on the right or left side to indicate the value
of the vertical bar.  It appears that I can only have (2)Yaxis values
displayed.  Is there a way to show more?

To create Multiple Y Axes in Excel, try Multy_Y or EZPlot at
www.OfficeExpander.com. There is a free demo version.
Cheers.

 

[Shane Devenshire]

Hi,

When you say you can only have 2 y-axis values, you don't mean that do you?
You can have as may values as you choose. Are you really asking how many
axis you can have?

Excel only allows 2 x and 2 y axis. If you want more you need to create
dummy axis.

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

Shane Devenshire

 

[Gklass]

I think I know what you have in mind.

Have you thought of plotting a vertical line on the left side of the
chart,
using data labels to turn it into an axis?

You would also have to play around with the X-axis labeling.

(I'm assuming an XY line chart)