Displaying target range across the Y axis.

  • Thread starter Thread starter Gary Clarke
  • Start date Start date
G

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.
 
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 said:
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.
Click to expand...

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.
 
Back
Top