Bar Chart Target Line

Hello,

edit your data source like in the screenshot.

Select the TargetX data including the column header and copy it.
Select the chart and use Paste special to paste as a new series
Format the series to the secondary axis and change the series chart type to XY Scatter with line and no markers.
Edit the chart source and change the scatter series to use the X and Y values from your data table
Edit the secondary Y axis and set the minimum to 0 and the maximum to 1
Format the line as you would like it and set the secondary Y axis to have no line, markers or labels (still not done in the screenshot).


See attached file.

cheers, teylyn

2016-08-16_18-55-04.gif