Gnatt Chart

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?
 
D

Del Cotter

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

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
I am taking the following steps.

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

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

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.
 
J

Jon Peltier

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
 
W

Workbook

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
 
W

Workbook

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

Ed
 
W

Workbook

Opps...typo. It was late, when I chose the title: ). Thanks for the
feedback Dave

Ed
 
J

Jon Peltier

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

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top