View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default How do I add a target line to a chart?

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.

--
Cheers,
Shane Devenshire


"soconfused" wrote:

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