I have the following data. (Duration2 = Duration x 0.000694) (0.000694 =
decimal equivalent of 1 minute)

A1 B1 End Duration Duration2
Activity 1 5:30 AM 6:15 AM 45 0.03123
Activity 2 6:15 AM 6:45 AM 30 0.02082
Activity 3 6:45 AM 6:50 AM 5 0.00347
Activity 4 6:50 AM 7:04 AM 9 0.006246
Activity 5 6:59 AM 7:04 AM 5 0.00347
Activity 6 7:04 AM 7:19 AM 15 0.01041
Activity 7 7:19 AM 7:44 AM 5 0.00347
Activity 8 7:24 AM 7:44 AM 20 0.01388
Activity 9 7:44 AM 8:04 AM 20 0.01388
Activity 10 8:04 AM 8:09 AM 5 0.00347
Activity 11 8:09 AM 8:29 AM 20 0.01388

I am taking the following steps.
1. Insert chart
2. Stacked bar
3. Next
4. Series in = columns
5. Series tab
6. Add
7. Name = B1
8. Values = B2:B11
9. Add
10. Name = Duration2
11. Values = E2:E11
12. Category (x) axis labels = Activity 1: Activity 11 (cells A2:A12)
13. Next
14. Next
15. Finish
16. As object in Sheet1
17. Format Axis double click
18. Scale Tab

I am trying to figure out what to put in the fields of the format axis for
the minimum, maximum, major unit, minor unit and category x axis crosses at
so that my Gnatt Chart begins at 5:30am, ends at 8:30am, and shows the bars
in 5 min intervals. I have been using the following data.

Minimum: .02291666 = 5:30 am
Maximum: 0.3541666 = 8:30 am
Major Unit: 0.00347222222 = 5 minutes
Minor Unit: 0.00347222222 = 5 minutes
Category X axis crosses at: 0.2291666 = 5:30 am

However, my chart is coming out all screwed up and I cant figure out why.
Do you have any thoughts that might help me to get this right?