Displaying target range across the Y axis.

[Gary Clarke]

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.

 

[bj]

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.

 

[David Biddulph]

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.

 

[Jon Peltier]

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/
_______