If you are using Excel 2003 or earlier, you can simply enter the times for
axis scale parameters. For example, min = 5:30 AM, max = 8:30 AM, major unit
= 0:30.

If you are using Excel 2007, you can't do this, because Microsoft broke this
functionality. You will have to figure out the numerical equivalents of
these times. For example, 5:30 = 5.5/24 or 0.2291666, 8:30 = 8.4/24 or
0.3541666, and 30 minutes = 0.5/24 or 0.0208333.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Workbook" wrote in message
...
I created a Gnatt Chart with 8 activities. The times on the values axis
are
listed as 3:50 AM, 4:19 AM, 5:16 AM, 6:14 AM, 6:43 AM, 7:12 AM, 7:40 AM,
8:09
AM, 8:38 AM, however since my activities take place between 5:30 AM and
8:15
AM, I wanted to decrease the time that is displayed on the chart
dramatically. For example, I would like to see the time on the values
axis
displayed in 5, 10, or 15 minute increments. I am assuming this requires
me
to adjust the minimum, maximum, major unit, minor unit, and category X
axis
data in the Format Axis, but I am not sure what to enter. Could you help
me
out with this