We have lots of properties of the chart. Let’s discuss few of them that might help to solve the visual appearance problems.
Select the Axis and press F4 key. In the opened property window, you will notice the below mentioned properties.
· VariableAutoInterval
If VariableAutoInterval=True is set then Chart Axis Interval will be calculated automatically based on available size.
If VariableAutoInterval=False is set then Chart Axis Interval will be calculated based only on the data range.
Chart1 and Chart2 will illustrate this property in the attached sample Report.
· Margin
If you want to start your chart series immediately without any margin then you need set the Margin=False.
Chart3 and Chart4 will illustrate this property in the attached sample Report. In chart4, Minimum value of the series is touching Y-axis whereas it is not in Chart3.
We can see the below properties under MajorGridLines, MinorGridLines, StripLines, MajorTickMarks etc. You can Refer Chart5’s MajorGridLines properties in attached sample regarding these.
· Interval
Setting this property states that in which interval you want to repeat the line/Mark.
· IntervalOffSet
Setting this property states the first occurrence of the line/Mark on the Axis.
· IntervalOffSetType
Setting this property states the unit of the first occurrence of the line/Mark on the Axis. If your Axis data type is not matching with any of the available values given under this, select the IntervalOffSetType as AUTO.
· IntervalType
Setting this property states the unit of the interval that will be considered by the Interval property.
You need to only change the report’s datasource. This RDL has been designed in SSRS 2008R2
