Graph on Inverted Scale

[Deepak Thakkar]

hi,

Can we draw an excel graph on an inverted scale

 

[Jon Peltier]

Do you mean in reverse order? Double click the axis, and check the
Values|Categories in Reverse Order box (and probably also the Axis
Crosses at Maximum box).

Do you mean plot vs. 1/x? Try this:

http://peltiertech.com/Excel/Charts/RecipAxisChart.html

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

 

[Deepak Thakkar]

thanx Jon .. values in reverse order worked.

thanx again for the hel