Marking a cutoff in ssrs 2005 charts

• BKAN

  SSC Journeyman

  Points: 78

  More actions

  December 15, 2009 at 12:12 pm

  #228545

  Hi all,

  I created a 3D column graph with months on x-axis and percentage values on y-axis. I need to have a red line at 98% indicating it as a cutoff. This helps the user to decide if they reached their goals.

  Can somebody suggest a solution for this.

• BKAN

  SSC Journeyman

  Points: 78

  More actions

  December 16, 2009 at 4:29 pm

  #1093349

  Hi all,

  I came across the following MSDN article which helped me in the above scenario. Following is the link to the article:

  http://msdn.microsoft.com/en-us/library/aa964128(SQL.90).aspx

  Scroll down to "Column and Line Hybrid Charts" and "To add a constant or dynamic target value to the chart: "

  Thank you.