Displaying target range across the Y axis.
 

I've created a spreadsheet to track my weight and my BMI readings (for
health (diabetes) and not vanity.

I'd like the Y axis of my chart to show two values/lines across the chart
indicating the lower and upper target range of my BMI reading. I know that
my weight won't flutuate so quickly to stand out against these ranges but
its the kind of aesthetic touch I like to add to my charts.

Thanks if you can help.

--
It's a 106 miles to Chicago. We got a full tank of gas, half a pack of
cigarettes, it's dark and we're wearing sunglasses.

If it is not a calculated value, You can just use the drawing toolbar,
select a line and drag it where you want on your chart. format them as you
wish.
You could also plot a line, but if doesn't need to be calculated, why
bother.

"Gary Clarke" wrote:

I've created a spreadsheet to track my weight and my BMI readings (for
health (diabetes) and not vanity.

I'd like the Y axis of my chart to show two values/lines across the chart
indicating the lower and upper target range of my BMI reading. I know that
my weight won't flutuate so quickly to stand out against these ranges but
its the kind of aesthetic touch I like to add to my charts.

Thanks if you can help.

--
It's a 106 miles to Chicago. We got a full tank of gas, half a pack of
cigarettes, it's dark and we're wearing sunglasses.

"Gary Clarke" wrote in message
...
I've created a spreadsheet to track my weight and my BMI readings (for
health (diabetes) and not vanity.

I'd like the Y axis of my chart to show two values/lines across the chart
indicating the lower and upper target range of my BMI reading. I know that
my weight won't flutuate so quickly to stand out against these ranges but
its the kind of aesthetic touch I like to add to my charts.

Assuming that you're plotting weight and BMI against date, add two extra
series, one with the value of BMI(lower) for both minimum date & maximum
date of the range you want to plot, and the other showing the value of
BMI(upper) for both minimum date & maximum date, then just add these two new
series to your graph.
--
David Biddulph

You could also plot a line, but if doesn't need to be calculated,
why bother.

If the scale changes or the chart is resized, the line will no longer
accurately reflect the intended value.

Here's another set of techniques:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


bj wrote:

If it is not a calculated value, You can just use the drawing toolbar,
select a line and drag it where you want on your chart. format them as you
wish.
You could also plot a line, but if doesn't need to be calculated, why
bother.

"Gary Clarke" wrote:


I've created a spreadsheet to track my weight and my BMI readings (for
health (diabetes) and not vanity.

I'd like the Y axis of my chart to show two values/lines across the chart
indicating the lower and upper target range of my BMI reading. I know that
my weight won't flutuate so quickly to stand out against these ranges but
its the kind of aesthetic touch I like to add to my charts.

Thanks if you can help.

--
It's a 106 miles to Chicago. We got a full tank of gas, half a pack of
cigarettes, it's dark and we're wearing sunglasses.