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 a

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lynne" wrote in message
...
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" wrote in message
...
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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lynne" wrote in message
...
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