Set dynamic Interval in Chart X or Y axis Interval

Hi R.B,

According to your description, we can write an expression to control the Interval of Y axis in a chart to achieve the goal. For more details, please refer to the steps below:

1. Right-click the X axis to open the Vertical Axis Properties dialog box.


2. Use the expression below to instead the Auto in the Interval option:=max(ceiling(Fields!x_axis_field_name.Value))/10

If we want to use a integer value as the interval, we can use the following expression:=ceiling(max(ceiling(Fields!x_axis_field_name.Value))/10)

If there are any other questions, please feel free to ask.

Thanks,

Katherine Xiong

---

Katherine Xiong

TechNet Community Support