A band indicating lower and upper bounds

[deebs]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Okay, I don't know if this is presently doable or not.

Think: Systolic and Diastolic blood pressure.

These are pointwise values yet both are usually paired up.

For instance one might wish for an upper line connecting one set of values (eg Systolic BP) and a lower line connecting all Diastolic values.

Yet at the same time wish for the banded, bounded areas to be highlighted in a chart.

See
http://ffmomw.bay.livefilestore.com...BQhhexuZk9g7FVlu87EUkzl3odKd3/100104_01a2.gif

for a visualisation.

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Okay, I don't know if this is presently doable or not.

Think: Systolic and Diastolic blood pressure.

These are pointwise values yet both are usually paired up.

For instance one might wish for an upper line connecting one set of values (eg
Systolic BP) and a lower line connecting all Diastolic values.

Yet at the same time wish for the banded, bounded areas to be highlighted in a
chart.

See
http://ffmomw.bay.livefilestore.com/y1pjvcNKXEbUZUQq3bWCjEWmnCUJNECpi8ZxAYvcUH
fSJajLcSHb9O6zZ64iWXF30PfdBFBQhhexuZk9g7FVlu87EUkzl3odKd3/100104_01a2.gif

for a visualisation.

What is the issue? Just plot the Systolic and diastolic pressures as 2
series.

 

[deebs]

2 series?

How to do?

 

[Bob Greenblatt]

2 series?

How to do?

Search Exce3l help on Series. There are several examples of adding data to a
chart.

 

[deebs]

Okay, thanks I will get round to looking that up soonest.

Now if I may refer to the image link in first post, what might be misleading in the chart?

HINT: a 2 degree shift in body temperature is a really serious thing.

So, follow on question is:
is there a way to have two different numerical scales on the vertical axis?

Say, for example, one range running 33 - 40 and dovetailing with a second scale running 40 - 160?

The idea here is that temperature range is a zoomed in scale if that makes any sense.

 

[Bob Greenblatt]

Okay, thanks I will get round to looking that up soonest.

Now if I may refer to the image link in first post, what might be misleading
in the chart?

HINT: a 2 degree shift in body temperature is a really serious thing.

So, follow on question is:
is there a way to have two different numerical scales on the vertical axis?

Say, for example, one range running 33 - 40 and dovetailing with a second
scale running 40 - 160?

The idea here is that temperature range is a zoomed in scale if that makes any
sense.

You can have 2 vertical axes with different values and scales. Each series
plots against one of the axes.