customize label on X axis

Hello

I'd like to draw a chart with measures done on a non-regularily basis. I can
make it with a single curve using a chronological axis in order to have a
distance between two points proportionnal to the elapsed time between them.
My problem is that Excel displays under the X-axis dates that are separated
by an uniform time. I'd like to see only the dates corresponding to the
measures. And I'd also like to have a vertical grid corresponding aligned
with the points ant not drawn with the same interval.

Does someone know a way to do this (if it's possible) ?
I must add that I want a graph where the Y-axis scale is automatically
defined (just the part concerning the values, the 0 should not be visible).

Thanks

Olivier Côte

Hi,
You'll find everything you need on Peltier's excellent=20
homepage;

http://www.geocities.com/jonpeltier/Excel/

You'll also need R. Boveys XY indispensable XY chart=20
labeller downloadable from http://www.appspro.com/

good luck

-----Original Message-----
Hello

I'd like to draw a chart with measures done on a non-
regularily basis. I can
make it with a single curve using a chronological axis=20
in order to have a
distance between two points proportionnal to the elapsed=20
time between them.
My problem is that Excel displays under the X-axis dates=20
that are separated
by an uniform time. I'd like to see only the dates=20
corresponding to the
measures. And I'd also like to have a vertical grid=20
corresponding aligned
with the points ant not drawn with the same interval.

Does someone know a way to do this (if it's possible) ?
I must add that I want a graph where the Y-axis scale is=20
automatically
defined (just the part concerning the values, the 0=20
should not be visible).

Thanks

Olivier C=F4te



.

I'd like to draw a chart with measures done on a non-
regularily basis. I can
make it with a single curve using a chronological axis
in order to have a
distance between two points proportionnal to the elapsed
time between them.
My problem is that Excel displays under the X-axis dates
that are separated
by an uniform time. I'd like to see only the dates
corresponding to the
measures. And I'd also like to have a vertical grid
corresponding aligned
with the points ant not drawn with the same interval.

On Thu, 23 Oct 2003 06:24:39 -0700, jacob
wrote:
You'll find everything you need on Peltier's excellent
homepage;

http://www.geocities.com/jonpeltier/Excel/

To be a little more specific, try
http://www.geocities.com/jonpeltier/...s.html#ArbGrid

--
Dave
dvt at psu dot edu