inverting the y axis

  • Thread starter Thread starter bob777
  • Start date Start date
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
 
Hi,

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

Regards,
B. R. Ramachandran
 
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/
_______
 
Back
Top