second vertical axis

K

KRK

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
 
S

ShaneDevenshire

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%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Odd chart type needed 2
can't click on series, close to Y-Axis 1
Position vertical axis 5
Create 2-Axis Combination Chart XL 2007 2
Multiple Y axis values 3
vertical scale on both ends of bar chart 1
Primary % secondard vertical axis don't line up 5
position of vertical axis 1

Top