VBA vs chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Interior color 1
dead chart 2
Create several charts in one go using VBA 4
Selecting a chart in a worksheet with VBA trouble 2
Problem when trying to set axis properties of a chart by VBA 2
Excel to Powerpoint 2003 Chart Width 2
chart.add gives compile error 2
Chart syntax 4

Back
Top