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.

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.