Hello,

XL 2002

I have the following data for an xy-chart. I would like to have months
as labels on the x-axis (like 1/05, 2/05 etc.) where the end of the
month should be labeled.

series1(cost)
x y
01.01.05 2
01.02.05 5
01.03.05 8
01.04.05 14

series2(revenue)
x y
15.01.05 4
10.03.05 10

series3(end of quarter)
x y
28.02.05 0
28.02.05 15

The problem is that there's no possibility to define dates for the
x-axis. The only thing I can do is using a number format like
"01".MM.YY or MM.YY. However, I get labels like this:
09/04
10/04
10/04
12/04
12/04
01/05
03/05
04/05 etc.

The intervall can be set eg. to 30, 31 or 30.4166667 (=365/12), but
still the labes do not work correctly. With some method I get correct
labels, however, the data does not fit, eg. 01.03.05 is between 02/05
and 03/05 and not very close to 02/05.

I think, I have to use xy-charts as other charts have problems with the
different periods and number of points esp. of series1 and series2 (I
do not need series 3 if I get correct lables on the x-axis).

regards

arno