On Wed, 20 Feb 2008, in microsoft.public.excel.charting,
Bandicoot said:
I am plotting information (Y axis) versus dates (X axis) using an X-Y
scatter chart. Is there any way to show "1 Jan", "1 Feb" etc on the X
axis as the tick marks and labels,
Use a Line Chart instead of a scatter, and if the x axis does not
automatically select Time-scale, then got to Chart Options.. Axes.. X
axis.. and choose Time-scale.
Then in Format Axis.. Scale, you can set the scale to calendar months.
That's how it works before 2007 anyway. You need to find the equivalent
menu options for 2007.
--
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.