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 !

Hi Barend,

Change the chart type to x-y scatter

Ed Ferrero
www.edferrero.com


> 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 !
>