Horizontally Banded Chart Background

  • Thread starter Thread starter Lynne
  • Start date Start date
L

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