Upper, Lower and mid limits on a line graph chart

• itwhiz

  Mr or Mrs. 500

  Points: 531

  More actions

  March 10, 2015 at 9:18 am

  #301940

  Hi,

  Help needed please with striplines in SSRS .

  I've created a line chart with 3 striplines Upper,Lower and Average.

  The data comes in as

  Fiscal Year,

  Month

  Count,

  Upper

  Lower

  Average

  The report runs fine and the Chart shows the different counts over the fiscal year(s)/Months, and the 3 striplines to show the Upper,Lower and Average values, but the data for these striplines can change monthly.

  BUT, it appears that the striplines only take the first value in the input data to set the display level and not by each record.

  Anybody got any idea how to get striplines to dynamically change as they go aross a chart.

  Thanks in advance