Export (0) Print
Expand All

How to: Highlight Chart Data by Adding Strip Lines (Report Builder 3.0 and SSRS)

Strip lines, or strips, are horizontal or vertical ranges that shade the background of the chart in regular or custom intervals. You can use strip lines to:

  • 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.

  • Highlight dates that occur at regular intervals. For example, in a sales report you might use strip lines to identify weekend data points.

  • Highlight a specific key range. Using the previous example, you can use one strip line to highlight the highest range of sales that is between $80-100.

Strip lines are not applicable to Shape or Polar chart types.

NoteNote

You can create and modify report definitions (.rdl) in Report Builder 3.0 and in Report Designer in Business Intelligence Development Studio. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder 3.0 (SSRS) on the Web at microsoft.com.

To display interlaced strip lines at regular intervals on a chart

  1. 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.

  2. Select the Use interlacing option. Grey strip lines will appear on your chart.

  3. (Optional) Specify a color for the strip lines using the adjacent Color drop-down list.

To display interlaced strip lines at custom intervals on a chart

  1. 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.

  2. In the Appearance section of the Properties pane, for the StripLines property, click the Edit Collection (…) button to open the ChartStripLine Collection Editor.

  3. Click Add to add a new strip line to the collection.

  4. 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.

  5. 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.

NoteNote

By default, Interval is set to Auto, which means the chart will not calculate an interval for custom strip lines. The chart only calculates intervals for strip lines if an interval value is set.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft