Gnatt Chart

  • Thread starter Thread starter Workbook
  • Start date Start date
W

Workbook

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 can’t figure out why.
Do you have any thoughts that might help me to get this right?
 
I have the following data. (Duration2 = Duration x 0.000694) (0.000694 =
decimal equivalent of 1 minute)
Click to expand...

Tip: If you custom number format your "Duration2" as h:mm, without the
AM/PM, it will display as "0:45" instead of "12:45 AM", so you won't
need two columns to display duration.
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
Click to expand...
I am taking the following steps.
Click to expand...

You're making your life too difficult for yourself, which increases the
chances of error. Arrange the chart so that three columns "A1", "B1"
(which you should call "Start"), and "Duration2" are all adjacent, then
use the chart wizard. You can always re-arrange the columns again later
when your chart has been successfully designed. The Chart wizard is the
only Microsoft wizard I know that the experts consistently use and
recommend, no matter how advanced they are. Its only true failing is
that it demands a blank cell in the top left, and never says so in the
documentation.
Minimum: .02291666 = 5:30 am
Click to expand...

I assume this is a typographical error, as the actual value should be
0.2291666
Major Unit: 0.00347222222 = 5 minutes
Click to expand...

5 minutes is much too small for the major unit, and you're probably
getting way too many labels (but you haven't said *how* your chart is
"coming out all screwed up"!). Try 30 minutes=0.02083333, and use minor
tick marks at five minute intervals.
 
Also, if you are using Excel 2003 or earlier, you can simply enter dates or
times into the scale parameter boxes in the Format Axis Scale dialog. This
prevents the .0229/.229 error Del noted, and makes life that much easier.

Excel 2007 does not offer this flexibility in axis parameter entry.

- Jon
 
Del I cannot thank you enough for your help or explain to you how much time I
have spent trying to figure this out. Thank you so much for clearing this up
for me! It works wonderful now. Thank you!

Ed
 
Jon, thank you for your ongoing help. I could not have gotten as far as I
did without your earlier help!

Ed
 
Sure, but sometimes Gantts are as annoying as gnats. More than once I've
intentionally used this spelling.

- Jon
 
Back
Top