How to: Specify an Axis Interval
The axis interval defines the number of labels and accompanying tick marks on an axis. On the value axis, axis intervals provide a consistent measure of the data points on the chart. However, on the category axis, this functionality can cause categories to appear without axis labels. You can specify the number of intervals you want in the axis Interval property. Reporting Services calculates the number of intervals at run time, based on the data in the result set. For more information about how axis intervals are calculated, see Formatting Axis Labels on a Chart.
This topic is not applicable for date or time values on the category the axis. Be default, DateTime values appear as days. To specify a different date or time interval, such as a month or time interval, you must format the axis labels and set the axis to display instances of DateTime types instead of String types. In addition, you must set the Interval property. For more information, see How to: Format Axis Labels as Dates or Currencies.
This topic does not apply to pie, doughnut, funnel or pyramid charts, which do not have axes.
To show all category labels on the x-axis
Right-click the category axis and click Axis Properties. The Axis Properties dialog box opens.
In Axis Options, set Interval to 1. Every category group label is displayed. If you want to show every other category group label on the x-axis, type 2.
When an axis interval is set, all automatic labeling is disabled. If you specify a value for the axis interval, you may experience unpredictable labeling behavior depending on how many categories are on the category axis.
To enable a variable interval calculation on an axis
Right-click the chart axis that you want to change, and then click Axis Properties. The Axis Properties dialog box opens.
In Axis Options, select the Enable variable interval option. An optimal number of category labels that can fit along the axis will be displayed.