Xaraam wrote:
Hey!!
Ive been having some troubles with Excel 2003 (SP2) chart.
Ive to do a chart which the x axis is date type data and in which the same
date has several values. Even the date table has some gaps: 1st cell:
01-01-2006; 2nd:02-01-2006; 3rd: 13-01-2006; 4th: 14-01-2006, etc

Now what is happening is if I just insert data on the Y axis and nothing on
the X axis, Ive got a completely different chart than if I add also the
dates on the X axis.
I need the chart result as the same without the dates on, but I do need to
put them there.

Im using a standard chart type €“ the line.
This is a sample of the data Im using:

75,6 |01-01-2007
32,1 |01-01-2007
7,6 |02-01-2007
0 |02-01-2007
9,4 |03-01-2007
71,8 |09-01-2007
0,8 |09-01-2007
0,8 |09-01-2007
2 |15-01-2007
0 |15-01-2007
Usually which date has a correspondence of at least 30 values, and the
average total cells are around 20000.

Can you u help me up?. Ive been fight this for a long time€¦ Im considering
going for VBA programming.


Not sure I follow you, but would this chart look better as an X-Y chart?
Drawing lines between the points would get very messy indeed since you
have multiple Y values at each X, and 20000 points. Also, the X-Y
version will allow you to space the X-axis dates proportionally, instead
of evenly spaced.