Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
charts - 1 column and 2 lines | Charts and Charting in Excel | |||
3D charts and limit lines | Charts and Charting in Excel | |||
Smooth lines for 3-D pie charts? | Charts and Charting in Excel | |||
lines on bar charts | Charts and Charting in Excel | |||
Charts with many lines | Excel Discussion (Misc queries) |