inverting the y axis
 

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


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=508937

inverting the y axis
 

Hi,

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

Regards,
B. R. Ramachandran

"bob777" wrote:


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


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=508937

inverting the y axis
 

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/
_______

"B. R.Ramachandran" wrote in
message ...
Hi,

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

Regards,
B. R. Ramachandran

"bob777" wrote:


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


--
bob777
------------------------------------------------------------------------
bob777's Profile:
http://www.excelforum.com/member.php...o&userid=28504
View this thread:
http://www.excelforum.com/showthread...hreadid=508937