Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2003

Tip: Looking for answers? Try searching our database.

Area Chart Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Phil Hageman - 10 Dec 2003 15:36 GMT
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 - 10 Dec 2003 16:07 GMT
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
[quoted text clipped - 27 lines]
>
> Thanks, Phil

Signature

Cheers
Andy

http://www.andypope.info

Phil Hageman - 10 Dec 2003 18:00 GMT
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.
>-----Original Message-----
>Hi Phil,
[quoted text clipped - 33 lines]
>>
>> Thanks, Phil
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.