Help with XY charts

[shdgv]

I want to plot a bunch a of data in VBA. my X axis is in "YYYY/MM/DD h:mm" format. when I plot it using XLline, it plots all the data from different times of one day under one X tang based on one day. for example it shows two vertical lines for dozens of data for two different days.
when I change the graph type to XLxyscatter, the problem is solved but I have no control on editing the chart as I need to control the minimum-maximum of Y axis and major units on X axis.

here is my code:

Please Login or Register  to view this content.

Basically when I choose XLxyscatter the part between starts is not run. Can someone help me please?
Attached you can see the Xlline and XYscatter results from the code.
scatter.jpg
line.jpg

[MrShorty]

This forum can be strict about rules -- like putting code in code tags. Please edit your post to include them, lest someone come along and prevent further replies to your topic.

I see no reason why you should not be able to adjust the axis limits of either axis, nor why the code in between the stars should not run. Can you upload a small sample file so we can see this in context?

[shdgv]

Thank you for the reply. It was my first time posting and did not know about the code tag rule.

The results of the code is frustrating to me. I do not get any errors for those lines but as you can see in the photos, the codes make no change on the axes.
any suggestions?

[MrShorty]

I am unable to debug for you. The only thing I noted is that startdate and finishdate are not assigned values, so the initial run through errored on those lines that set the range. Once I assigned suitable values to those variables (I used 2 and 20, since those are the rows I used for the dummy data I tested on), the code seemed to run just fine. I guess I can suggest that you check the values for startdate and finishdate (using locals window or other debug tool: http://www.cpearson.com/excel/DebuggingVBA.aspx ) and make sure they are reasonable. Other than that, I see nothing wrong with the code you posted.