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?

On Wed, 17 Dec 2008, in microsoft.public.excel.charting,
Workbook said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Del Cotter" wrote in message
...
On Wed, 17 Dec 2008, in microsoft.public.excel.charting,
Workbook said:

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.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

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

Ed

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Del Cotter" wrote in message
...
On Wed, 17 Dec 2008, in microsoft.public.excel.charting,
Workbook said:

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.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

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

"Del Cotter" wrote:

On Wed, 17 Dec 2008, in microsoft.public.excel.charting,
Workbook said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Gantt, not Gnatt
--
David Biddulph

"Workbook" wrote in message
...
....
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.
....

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

Ed

"David Biddulph" wrote:

Gantt, not Gnatt
--
David Biddulph

"Workbook" wrote in message
...
....
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.
....

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

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


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Gantt, not Gnatt
--
David Biddulph

"Workbook" wrote in message
...
...
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.
...