I was following the instruction from here: http://msdn.microsoft.com/en-us/library/dd239316.aspx for setting up Date type interval and set it to Month and everything is showing up correctly, however if I narrow my interval to several days within month then chart again showing up correct data but don't label the days on x-axis. Is it possible to have days labels displayed having the month to be set as default interval?
0
votes
1 Answers
0
votes
To format x-axis labels as daily intervals
1. Right-click the horizontal, or x-axis, of the chart, and select Horizontal Axis Properties.
2. In the Horizontal Axis Properties dialog box, select Number.
3. From the Category list, select Date. From the Type list, select a date format to apply to the x-axis labels. Select Axis Options.
4. In Interval, type 1. In Interval type property, select Days.
Note: If you do not specify an interval type, the chart will calculate intervals in terms of days. Click OK.
