Area Chart Problem

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

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

Phil said:
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
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.
 
Back
Top