Date-time axis in chart

[Barend]

Hi,

In my data sheet the first column is date-time and then a second column for the graph.

07/01/01 10
07/04/05 15
08/01/01 12

The format for first column is: Date then I selected 2001-03-14 (predefined) as Type.

When I draw a chart, the hor. axis does not show like a date-time axis. With format-axis I also
selected the same date-time format as in the sheet. And linked to the source. I see the correct
date-time labels along the axis, but if I change a date-time in the sheet, the label on the axis
also changes but not the position on the horizontal axis.

Any idea what might be wrong ?

Thanks !

 

[Ed Ferrero]

Hi Barend,

Change the chart type to x-y scatter

Ed Ferrero
www.edferrero.com