Area Chart Problem

[Phil Hageman]

In an area chart I want five color bands across the chart,
over which a single line series is plotted. The Y axis is
set Minimum 70%, Maximum 115%. The area series are:

Plot area - Red (Y axis set at 115% maximum)
Upper Op Zero - 100% Yellow
UCL - 95% Green
Target - 90% (a line series)
LCL - 85% Yellow
Lower Op Zero - 70% (Axis minimum) to 80% Red

The problem, only two bands show:
Upper Op Zero, yellow, from 70% to 100%
UCL, Green, from 100% to 115%

Not all the area series show. It's as though the two
bands are covering up others (nothing else visible to
click on to format). The line series (Target) is plotting
correctly.

I should have five bands:
100% to 115% (Plot area, Red)
95% to 100% (Upper Op Zero, Yellow)
85% to 95% (UCL, Green)
80% to 85% (LCL, Yellow)
70% to 80% (Lower Op Zero, Red)

Does anyone have a suggestion as how I can adjust things
to make the five bands work correctly?

Thanks, Phil

 

[Andy Pope]

Hi Phil,

Sure you haven't used Stacked area charts by mistake.
Try normal area, you may have to reverse the series order as well.

In an area chart I want five color bands across the chart,
over which a single line series is plotted. The Y axis is
set Minimum 70%, Maximum 115%. The area series are:

Plot area - Red (Y axis set at 115% maximum)
Upper Op Zero - 100% Yellow
UCL - 95% Green
Target - 90% (a line series)
LCL - 85% Yellow
Lower Op Zero - 70% (Axis minimum) to 80% Red

The problem, only two bands show:
Upper Op Zero, yellow, from 70% to 100%
UCL, Green, from 100% to 115%

Not all the area series show. It's as though the two
bands are covering up others (nothing else visible to
click on to format). The line series (Target) is plotting
correctly.

I should have five bands:
100% to 115% (Plot area, Red)
95% to 100% (Upper Op Zero, Yellow)
85% to 95% (UCL, Green)
80% to 85% (LCL, Yellow)
70% to 80% (Lower Op Zero, Red)

Does anyone have a suggestion as how I can adjust things
to make the five bands work correctly?

Thanks, Phil

--

Cheers
Andy

http://www.andypope.info

 

[Phil Hageman]

Andy, you are exactly correct, one of the series was
formatted as a stacked area. Once changed to area,
everything works as intended. Thanks again and have a
great holiday.