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.