second vertical axis

Hello,

I have a simple vertical bar chart which is getting very big. I want to show
the y-axis (vertical) values at both the left and right-hand sides. Can
someone point the way please.

Thanks

KK

Hi,

http://www.andypope.info/tips/tip005.htm

Cheers
Andy

KRK wrote:
Hello,

I have a simple vertical bar chart which is getting very big. I want to
show the y-axis (vertical) values at both the left and right-hand sides.
Can someone point the way please.

Thanks

KK

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi,

If you have more than one series, double-click the second series and on the
Axis tab select Secondary Axis

If your series have highly different values you may want to force both axes
to display the same values by double clicking a Y-axis and on the Scale tab,
setting the Maximum manually. You may need to do that for both Y-axes.

If you only have a single series, you can plot the same series twice. Then
double click the second series and on the Axis tab choose Secondary Axis and
on the Options tab set Overlap to 100%

--
Thanks,
Shane Devenshire


"KRK" wrote:

Hello,

I have a simple vertical bar chart which is getting very big. I want to show
the y-axis (vertical) values at both the left and right-hand sides. Can
someone point the way please.

Thanks

KK

Thanks all, this works nicely

K



"KRK" wrote in message
...
Hello,

I have a simple vertical bar chart which is getting very big. I want to
show the y-axis (vertical) values at both the left and right-hand sides.
Can someone point the way please.

Thanks

KK