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?
--
Steve

On Jan 17, 10:37*am, Flashoflight
wrote:
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?
--
Steve

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

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

"Flashoflight" wrote in message
...
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?
--
Steve

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)