ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I add a target line to a chart? (https://www.excelbanter.com/charts-charting-excel/146662-how-do-i-add-target-line-chart.html)

soconfused

How do I add a target line to a chart?
 
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

ShaneDevenshire

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



All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com