Value Axis Adjustment
 

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

Value Axis Adjustment
 

in Excel every dat/time has its numeric representation

e.g. 00:05:00 (=5 minutes) equals 0,00347222222222222.
today's date equals 39795

to achieve the a/m results format 00:05:00 or todays' date as Number
allowing for required number of decimals

try to play with major/minor units, minmum and maximum, according to
this scheme

HIH

On 13 Gru, 05:48, Workbook wrote:
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