Real Month labels on a X-Y Scatter chart

[C Dub]

Is there a way of plotting an x-y data set where X is a date, configuring
the x-axis to display even monthly intervals (i.e. uneven date intervals)?
When plotting a year or so, you can cheat by setting the scale Major Unit to
32 and formatting the date to show MMM-YY but the error accumulates and
every once in a while you get the wrong month. I don't want to use a line
chart as sometimes I need to see where in the month the reading falls and
other times there are more than one reading per month.

Thanks for any help.

[Peltier]

Hi C Dub -

That's not "Dubya", is it?? (Sorry...)

You could use a line chart with a time axis for the x axis. Set your
base unit as months, and your major and minor units as 1 and the chart
will put ticks on the first of every month in the range. Set your
number format to mmm-yy. I usually try to convince people to use an XY
Scatter plot, but I'll make an exception in this case.

- Jon
_______

[C Dub]

For reasons I noted below, I prefer not to use a line chart. DeltaGraph
does this (and a number of other things) nicely, but it doesn't have the
data processing capabilities and I hate having to move data back and forth.

"Peltier" <pel...@home.com> wrote in message
news:3A5E6F92...@home.com...

[Peltier]

Did you try a time scale axis? If you set your major unit to one month,
and the minimum to the first of a month, each tick mark is exactly the
first of a month. Sometimes the ticks are closer (30 or 28 days) and
sometimes farther (31 days). Data are spaced according to time between
points, not equally spaced. No fudging needed. If you have only a
category axis, go to Chart Options > Axes, and pick the Time-Scale
option. Your data has to be recognizable as dates for it to work
reliably.

- Jon

P.S. I was going to copy you directly, but that didn't seem like a real
email address!