A. Improve readability for looking up individual values on the chart. Specify strip lines at regular intervals to help separate data points when reading the chart
To display interlaced strip lines at regular intervals on a chart
- To show horizontal strip lines, right-click the vertical chart axis and click Vertical Axis Properties.
To show vertical strip lines, right-click the horizontal chart axis and click Horizontal Axis Properties.
- Select the Use interlacing option. Grey strip lines will appear on your chart.
- (Optional) Specify a color for the strip lines using the adjacent Color drop-down list.
- To show horizontal strip lines, right-click the vertical chart axis and click Vertical Axis Properties.
To show vertical strip lines, right-click the horizontal chart axis and click Horizontal Axis Properties.
The axis properties are displayed in the Properties window.
- In the Appearance section of the Properties pane, for the StripLines property, click the Edit Collection (…) button to open the ChartStripLine Collection Editor.
- Click Add to add a new strip line to the collection.
- Click StripWidth to specify the width of the strip line, measured in inches on the report. If you are highlighting dates or times, click StripWidthType and select a time interval.
- Type a value or expression for the Interval to specify how often the strip line will repeat. For example, if you specify an interval of 10, and your strip line width is 5, strip lines will display at values of 0 to 5, 15 to 20, 30 to 35, and so on.
B. ADD TOOL TIP IN THE SERIES DATA POINTS
Sample expression:=Fields!Month.Value + Chr(10) + Format(Sum(Fields!Sales_Value.Value), "#,#,;(#,#,)")
C: TRIM VALUE FOR CHART CATEGORY TO MAKE IT SMALLER
Use Left/Right fuction
Sample Code: =Left(Fields!Month.Value, 3) + Right(Fields!Month.Value, 2)
Sample Output: Nov 10 which suppose to be November 2010
D. SORT CHART MONTH CATEGORY (LATEST - CURRENT) - Apply to SSRS MDX Report
In the category group properties, select sorting then use Filed.UniqueName - A-Z