Amending chart in VBA - problem with XValues in xlXYScatter

Having trouble with the following code:

Please Login or Register  to view this content.

The code executes, there are no syntax errors. The XValues are in date format, as per the data in Column A. When I step through this in the debugger, when I execute the XValues statement above, the X-axis has the correct labels, in date format. When the next statement executes, the XValues change to take the values 1 to 4.5, in 0.5 increments. This grading is based on the number of observations, 4. I know this because if I increase the number of observations to 10, the XValues scale changes to 1 to 10. I don't want it to change from what I've set it to, i.e. the date values in Column A. However, if I run the XValues statement after setting the chart type, it doesn't change back. What is wrong?

I've answered my own question...it turns out that the dates in column A were not being treated as dates by Excel. This is because, when the file is opened using Workbooks.Open , Excel reads in the dates using the m-d-y format by default. Mine are in d-m-y format as I'm in the UK. The workaround was in specifying the Local keyword in the Open statement, as follows:

Please Login or Register  to view this content.

So it wasn't actually a problem with the Chart at all - that fixed itself as soon as I made this change.