How to set a target line in column chart

[n/a]

Is there any way to set a target line in a column chart? In the attached image, I have an additional line chart inside of the column chart and changed the data point style to make it a longer line. Ideally I would like it to span across the full chart.

 

Thanks for your help.

[Mads]

Hello Spencer,

I believe we have a solution to create the graph you want. Below you can see a screenshot from a report I created with the resulting target-line

The report with the graph from the picture above is attached to this reply. I will explain the steps needed to add this line

1. Open up the Series editor for the graph by clicking the little button with '...' inside the properties.
   
2. Add a new lineSeries
3. Set the following properties of the new lineSeries
   1. LineType: Stepped (this will make the line reach from start to end of the xAxis)
   2. CoordinateSystem, CategoryGroup and SeriesGroup to the same values as the existing barSeries(should be only one choice)
   3. Y: = 0,8 or the value you want as a target
   4. Value: The title/legend you want to be displayed next to the graph to explain what the line is
      
      

Does this result in the graph you want? The setup might depend slightly on how your already existing graph is set up. Let me know if it works out, if you run into challenges, or have any other questions.

Regards, Mads Progress Telerik