customize label on X axis

[Olivier Côte]

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
(e-mail address removed)

 

[jacob]

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

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

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

good luck

 

[dvt]

I'd like to draw a chart with measures done on a non-

regularily basis. I can

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/Excel/Charts/axes.html#ArbGrid