Thanks for your reply. Setting Axis.X.Labels.Layout.Behavior = Auto and Axis.X.Labels.TickmarkStyle = Smart still doesnt work because the labels dont show up correctly. The dates are displayed as 'Mar-2...' instead of 'Mar-2007'.

 Also, is there any way to limit the number of points shown instead of the labels? Thanks

I sorted this out by using percentage TickmarkStyle and set the percentage property in the chart object.

 However, I still have a problem related to the data points. Check out the attached image. There are so many "black dots" (i.e. data points) that you cant really see the underlying color. I am looking for a way to make these "black dots" more discrete (i.e. smaller/non-existent/different color etc.)

 Hope there is a way....Thanks

In above spline chart you have drawn majorgridlines on x-axis....how you draw these lines on tickmarkinterval only....

this.Axis.X.MajorGridLines.Visible=true;

but I am not getting these lines on my graph....also when i  am setting 

this.Axis.X.MinorGridLines.Visible=true;

i am getting lines for all the datapoints which i dont want.....

the pictured spline chart uses a time axis, which changes the way labels and gridlines are drawn.  the default settings for spline chart use a string axis, so the only location you can draw gridlines at is at each point.

I did this setting earlier still its not showing majorgridlines on x-axis