Static y-axis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

quattda - 04 Sep 2007 04:16 GMT

I have a chart that displays the relative percentages of two values. The
y-axis value range changes as the values change. I would like the y-axis to
remain a range from 0% to100% no matter what the actual percentage values
are. Is there a way to do this?

Reply to this Message

Andy Pope - 04 Sep 2007 08:33 GMT

Hi,

Double click the Y axis and on the scale tab set the Maximum value to 1
(100%). This should uncheck the Auto option.
Do the same for the Minimum values setting it to zero.

Cheers
Andy

Signature

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

>I have a chart that displays the relative percentages of two values. The
> y-axis value range changes as the values change. I would like the y-axis
> to
> remain a range from 0% to100% no matter what the actual percentage values
> are. Is there a way to do this?

Reply to this Message

David Biddulph - 04 Sep 2007 08:48 GMT

Double click on the axis. Go to the scale tab. Set the max & min values
you want and ensure that the auto boxes against those are unchecked.

Signature

David Biddulph

Reply to this Message