Horizontally Banded Chart Background

[Lynne]

Hi,
Am following Jon Peltier's tutorial for horizontal colour banding. However
when i convert the line graphs to stacked area type the colouring is not
appearing per the bands its suppossed to reflect.

eg.
i have ranges with upper limits 2.5; 5; 7.5;10 and can only get the band
correct between 0-2.5 ... what am i doing incorrectly?

Lynne

 

[Jon Peltier]

Do all the bands appear? If not, have you converted all of the band series
to area type? If so, are they simply unfilled? You can format the unfilled
bands to be filled. Or are the band spacings incorrect? Using a stacked area
type, your data must be the difference between bands (i.e., with bands at
2.5, 5, 7.5 and 10, you need four bands 2.5 high).

- Jon

 

[Lynne]

Jon,
I can manage only 3 bands not 4 and yes I have converted all the bands to
the area type.
The lowest band 0 to 2.5 appears correctly
The next band spans the series 2.5 to 7.5 and not 2.5 to 5.0 and covers
series 5.0
The last band 7.5 to 10 should reflect the data between 10 and 7,5 but
covers series 7.5

2.5; 5.0; 7.5; 10 are upper limits and series names i have used.
Lynne

 

[Jon Peltier]

It sounds like you are stacking the area series, which means you need to
plot the difference between the band's upper limit and the previous band's
upper limit. If you do not do this your bands will plot:

2.5
7.5 = 2.5+5.0
15.0 = 7.5+7.5
25.0 = 15.0+ 10.0

which is what you have, but your Y axis stops at 10, so only part of the
third band and none of the fourth appear.

All four bands should be plotting values of 2.5, so the upper limits are:

2.5
5.0 = 2.5+2.5
7.5 = 5.0+2.5
10.0 = 7.5 + 2.5

An alternative way to think of it is you need your values all to be 2.5:

2.5 = 2.5-0.0
2.5 = 5.0-2.5
2.5 = 7.5-5.0
2.5 = 10.0-7.5

- Jon

 

[Lynne]

Thanks Jon.,

I was doing just what you pointed out. I have now plotted the differences
between the 2 bands and have got it right.
Thanks for your detailed explanation it has been very enlightening..

Lynne