VBA vs chart

[Paal]

Hi everybody, I have a problem I don't seem to be able to solve, maybe you
can help.
The following code add a chart:

Dim objChart As ChartObject
With ActiveSheet
Set objChart = .ChartObjects.Add(Left:=100, Width:=575, Top:=75, Height:=325)
objChart.Chart.SetSourceData Source:=Sheets("Data").Range("M11:O26")
objChart.Chart.ChartType = xlXYScatterLines
With objChart.Chart
..PlotArea.Interior.ColorIndex = xlNone
..Refresh
End With
End With

Column M11:M26 contain dates and time (in the following format 13.03.2006
14:15:00). After running this code the chart is created but it only show
00:00:00 on the x axis. Anyone know why or have any tip of how to solve this?

Thanks
Paal

 

[Nigel]

Your code works fine in Excel 2002 and Excel 2003 on my PC, ensure the date
cells are correctly formatted and not contain invalid or missing values.

 

[Paal]

I've tried it one more time after changing the number format of the column
and it was now ok. Thanks for the tip.

Paal