Previous Thread

8/17/2006 11:27:52 AM    Y-Axis scale from high to low going vertically?
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.



8/17/2006 9:02:29 PM    Re: Y-Axis scale from high to low going vertically?
Hi, 
 
Double click the value axis (Y) and on the scale tab set 
 
Values in Reverse order 
 
Category axis crosses a Maximum 
 
Cheers 
 
Andy 
 
Chuck wrote: 
 
-- 
 
Andy Pope, Microsoft MVP - Excel 
 
http://www.andypope.info