Wrong date on x-axis in line chart

Hi,

I have a table in excel with two columns, one with dates (2010-01-01 to 2010-12-31) that I put on the x-axis and one column with values that I put on the y-axis. The dates are fomatted as YYYY-MM-DD. (My excel is installed with swedish language so in swedish the format is actually shown as ลลลล-MM-DD.)

Whe I create an (embedded) chart (line chart or scatter chart) the dates on the x-axis starts at 1900-01-01 and the x-axis scale in the chart corresponds to one day per line in the table. The actual values of the dates in the table seems to be completely ignored when the chart is generated. If I manually edit the scale of the x-axis the currency values disappears (they fall outside the time scope).

Can anybody help me getting correct dates on the x-axis ?

I use Excel 2002 SP3, running under Windows XP 2002 home edition SP3.

BR /S๖ren