Re: Area Charts - Filling in above only
- From: Tushar Mehta <tmUnderscore200310@xxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 3 Dec 2005 08:01:30 -0500
Create a stacked area chart with one line for each of the zones of
interest (and one for mid point line). If all the zones are of equal
size, use a y value of 1 for each series. Alternatively, adjust them
for your own requirements.
0 1
Empty space 1 1
Danger zone 1 1
Safe zone 1 1
Midpoint 0 0
Safe zone 1 1
Danger zone 1 1
Empty space 1 1
In step 2 of the chart wizard ensure you select 'data are in rows.'
Now, format each zone as desired.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <5836CB65-DECE-4115-9C5B-0A3208BF927E@xxxxxxxxxxxxx>,
Catalina@xxxxxxxxxxxxxxxxxxxxxxxxx says...
> I have four lines that each define a horizontal zone. When I change each to
> an Area Chart, it appears that the color is only painted above each line and
> the color extends from the line all the way to the top of the chart. But
> above the top line I'd like this to be uncolored. I want the top two areas
> are filled in BELOW each line to a horiz. mid-point on the chart and the
> bottom two areas are filled in ABOVE these lines to a horiz. mid-point. In
> effect I want the chart to depict from top to bottom:
>
> Empty space
> Danger zone
> Safe zone
> Safe zone
> Danger zone
> Empty space
>
> Help!!
>
>
>
>
.
- Prev by Date: Re: stacked bar charts
- Next by Date: Re: How do you combine a stacked column and single column graph?
- Previous by thread: Re: stacked bar charts
- Next by thread: Re: Area Charts - Filling in above only
- Index(es):
Relevant Pages
|
