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.