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

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

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

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

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