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