ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Does anyone know how to put in reference lines in charts? (https://www.excelbanter.com/excel-discussion-misc-queries/214081-does-anyone-know-how-put-reference-lines-charts.html)

Bharat[_2_]

Does anyone know how to put in reference lines in charts?
 
I am trying to chart my blood sugar. In the charts, I am using:
(1) Less than 140
(2) Between 140 and 160
(3) Higher than 160.

Is it possible to put in reference lines at 140 and 160 of a different color
so when I plot my blood sugars for after luncha nd after dinner, wherever the
points on the curve are, should tell me graphically in which of the three
areas the points are.

Thank you for all your help.
--
Bharat

David Biddulph[_2_]

Does anyone know how to put in reference lines in charts?
 
Add a couple of new series to your data sheet:

X=Xmin, Y=140
X=Xmax, Y=140

X=Xmin, Y=160
X=Xmax, Y=160

Add those 2 extra series to your graph.
--
David Biddulph

"Bharat" wrote in message
...
I am trying to chart my blood sugar. In the charts, I am using:
(1) Less than 140
(2) Between 140 and 160
(3) Higher than 160.

Is it possible to put in reference lines at 140 and 160 of a different
color
so when I plot my blood sugars for after luncha nd after dinner, wherever
the
points on the curve are, should tell me graphically in which of the three
areas the points are.

Thank you for all your help.
--
Bharat





All times are GMT +1. The time now is 09:55 PM.

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