How do I add a target line to a chart?

[soconfused]

I have a blood pressure spreadsheet and I want to add target diastolic and
systolic lines. Is there an easy way to do this?

 

[ShaneDevenshire]

Hi,

Create two new series, one for each line. For each series all the numbers
are the same. Highlight the new data series and copy them. Click on the
chart and paste them. If they are not lines, single click one of the new
series and choose Chart, Chart Type, and change to a line. Repeat for the
other line. Double click one of these lines and on the Patterns tab set the
Markers to None. repeat.