Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I'm doing up a graph to plot Body Mass Index. Easy calculation based on
weight and height, and will plot it at one month intervals as part of a weight loss charting method. As you probably know, BMI is broken down into certain cetagories (ie 0-18.4 (underweight)), 18.5-24.9 (normal), 25-29.9 (overweight), over 30 (obese). I'd like each of these categories (ie horizontal zones) a different color, and then on top of this "background" plot the actual values. One can then look at the change over a weight loss program. I plan of having BMI as the y axis and various dates along the x. I assumed you'd paste a new series... however, I can do that for the first value (ie 0-18.4), but I'm having trouble adding the next "zone".. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Relocating reference numbers for many blocks of data | Excel Discussion (Misc queries) | |||
Graph A Horizontal Line | Charts and Charting in Excel | |||
Adding Horizontal line to a graph | Excel Discussion (Misc queries) | |||
Possible to Add Horizontal Line to Embedded Graph via VBA? | Charts and Charting in Excel | |||
Y Axis - Horizontal Bar Graph | Charts and Charting in Excel |