inverting the y axis

B

bob777

Is there any way that I can plot a line chart of accidents per month,
with the y axis going from 20 UP to zero, instead of the normal zero to
20 ?

thanks in advance,

Bob
 
B

B. R.Ramachandran

Hi,

Rightclick on the y axis --> "Format Axis" --> select "Scale" Tab and check
"Values in reverse order" --> "OK"

Regards,
B. R. Ramachandran
 
J

Jon Peltier

To keep the X axis at the bottom, also check the Category Axis Crosses At
Maximum checkbox.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Top