I have the following data set (sample) with scores for A, B, and C. I've created a Line chart using this data. I now need to add a horizontal target line that spans the chart, using the value in the Goal column. I've tried the approach of creating a chart with all values, then selecting the Goal value and changing the Series Chart Type. This is not working, as it's changing the entire chart. Any help would be appreciated. Thanks in advance.
Measure A B C Goal
C01 51 55 60 50