How to control the X-Axis label intervals with Date Format

See more:

SSRS

HI all i have a requirement where i have to show the data in a chart for every minute between a start and end time of a trade. if that trade is a intraday i have to show the data for every hour and if its more than a day i have to show it based on day. i was trying this but i couldnt achieve it using a category chart as i was getting soem random dates which is not making any sence to the chart

For Example
I have trade from 21 march to 30 march.
I have to show the axis points as 21march ,22march ,23march ,24march ...30march
but it is coming up as 22march 24march 27 march 30march.
And for intraday the same thing instead of days i am getting some random hours.


I tried the scalar chart works pretty good for intraday trades but if its like more than 10 days i am getting some weired straight lines between the days staurday and sunday since the sclar type axis wont care about the data points i have.

I am kind of confused can anyone suggest me some ideas or refrences on doing this.Please let me know if i am not clear with the question.