Graph with horizontal color blocks marking certain numbers
 

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.

Graph with horizontal color blocks marking certain numbers
 

Jon Peltier's site provides an example of what you're trying to achieve:

http://peltiertech.com/Excel/ChartsH...orizBands.html

--
John Mansfield
http://cellmatrix.net





"Scott" wrote:

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.