Y-Axis scale from high to low going vertically?

[Guest]

How do you force the Y-axis to start at a high number in a series of data
points, and move lower as you go up the axis? I have data about performance
(network delay) that has a goal of zero. Actuals are 20, 40, 50 milliseconds
average per month. X-axis is a category-axis with months listed. The average
has been decreasing, and I would like to show this as a line graph slanting
from the lower left to the upper right, as it approaches 0.

 

[Andy Pope]

Hi,

Double click the value axis (Y) and on the scale tab set
Values in Reverse order
Category axis crosses a Maximum

Cheers
Andy

 

[Guest]

The only combination of options I did not try, of course!
Perfect, and thank you!