I have charted two learning curves... the curves are basically parallel with
one another... one is just slightly higher than/above the other. I want to
fill the area below the lower of the two curve with one color; the area above
the higher of the two curves with a second color; and leave the area between
the two curves without any color. How?

The color fill button on my toolbar fills the entire plot area with one color.

Thanks in advance, Elaine

You might check out this:

http://peltiertech.com/Excel/Charts/format.html#XYArea

Several ways of adding background fills.

--
Best Regards,

Luke M
"psychobug" <(E-Mail Removed)> wrote in message
news:28199EE9-EAF1-4801-BD80-(E-Mail Removed)...
>I have charted two learning curves... the curves are basically parallel
>with
> one another... one is just slightly higher than/above the other. I want
> to
> fill the area below the lower of the two curve with one color; the area
> above
> the higher of the two curves with a second color; and leave the area
> between
> the two curves without any color. How?
>
> The color fill button on my toolbar fills the entire plot area with one
> color.
>
> Thanks in advance, Elaine

I'm posting this for others who may search for this in the future as I have.

Most every discussion group ended up pointing to the same page. http://peltiertech.com/Excel/Charts/BackgroundFill.html It has very good info but I was looking for something quicker. I came up with the following low-tech method to create color bands behind the plot area.

Create your plot as usual. Make sure your page zoom is at 100%. Press ALT+PrintScreen to copy Excel window to clipboard (Excel must be active window). Open Microsoft Paint. Press CTRL+V to paste screenshot. Move/clip image so you only have the plot area remaining.


By agthad at 2010-12-13

> On Friday, February 26, 2010 11:56 AM psychobug wrote:

> I have charted two learning curves... the curves are basically parallel with
> one another... one is just slightly higher than/above the other. I want to
> fill the area below the lower of the two curve with one color; the area above
> the higher of the two curves with a second color; and leave the area between
> the two curves without any color. How?
>
> The color fill button on my toolbar fills the entire plot area with one color.
>
> Thanks in advance, Elaine


>> On Friday, February 26, 2010 12:48 PM Luke M wrote:

>> You might check out this:
>>
>> http://peltiertech.com/Excel/Charts/format.html#XYArea
>>
>> Several ways of adding background fills.
>>
>> --
>> Best Regards,
>>
>> Luke M


>> Submitted via EggHeadCafe
>> JQuery Templates and the Topsy Otter Twitter Search API
>> http://www.eggheadcafe.com/tutorials...earch-api.aspx

I'm posting this for others who may search for this in the future as I have.

Most every discussion group ended up pointing to the same page. http://peltiertech.com/Excel/Charts/BackgroundFill.html It has very good info but I was looking for something quicker. I came up with the following low-tech method to create color bands behind the plot area.

Create your plot as usual. Make sure your page zoom is at 100%. Press ALT+PrintScreen to copy Excel window to clipboard (Excel must be active window). Open Microsoft Paint. Press CTRL+V to paste screenshot. Move/clip image so you only have the plot area remaining.


By agthad at 2010-12-13

> On Friday, February 26, 2010 11:56 AM psychobug wrote:

> I have charted two learning curves... the curves are basically parallel with
> one another... one is just slightly higher than/above the other. I want to
> fill the area below the lower of the two curve with one color; the area above
> the higher of the two curves with a second color; and leave the area between
> the two curves without any color. How?
>
> The color fill button on my toolbar fills the entire plot area with one color.
>
> Thanks in advance, Elaine


>> On Friday, February 26, 2010 12:48 PM Luke M wrote:

>> You might check out this:
>>
>> http://peltiertech.com/Excel/Charts/format.html#XYArea
>>
>> Several ways of adding background fills.
>>
>> --
>> Best Regards,
>>
>> Luke M


>>> On Monday, December 13, 2010 5:09 PM Thad Ayres wrote:

>>> I'm posting this for others who may search for this in the future as I have.
>>>
>>>
>>>
>>> Most every discussion group ended up pointing to the same page. http://peltiertech.com/Excel/Charts/BackgroundFill.html It has very good info but I was looking for something quicker. I came up with the following low-tech method to create color bands behind the plot area.
>>>
>>>
>>>
>>> Create your plot as usual. Make sure your page zoom is at 100%. Press ALT+PrintScreen to copy Excel window to clipboard (Excel must be active window). Open Microsoft Paint. Press CTRL+V to paste screenshot. Move/clip image so you only have the plot area remaining.
>>>
>>>
>>>
>>>
>>>
>>> By agthad at 2010-12-13


>>> Submitted via EggHeadCafe
>>> Sterling Database for Silverlight and Windows Phone 7
>>> http://www.eggheadcafe.com/tutorials...s-phone-7.aspx

I'm posting this for others who may search for this in the future as I have.

Most every discussion group ended up pointing to the same page. http://peltiertech.com/Excel/Charts/BackgroundFill.html It has very good info but I was looking for something quicker. I came up with the following low-tech method to create color bands behind the plot area.

Create your plot as usual. Make sure your page zoom is at 100%. Press ALT+PrintScreen to copy Excel window to clipboard (Excel must be active window). Open Microsoft Paint. Press CTRL+V to paste screenshot.

http://img257.imageshack.us/img257/3...wertransfe.gif

Move/clip image so you only have the plot area remaining.

http://img697.imageshack.us/img697/3...wertransfe.gif

Use Paint tools to create your color bands. I found it easiest to delete the grid and then draw a filled box. It doesn't even have to be the whole size of the plot area, just the correct width. Save the new image. (GIF is nice and small)

http://img830.imageshack.us/img830/3...wertransfe.gif

Go back to Excel. Right click on the plot area and select Format Plot Area. Select Fill Effects and Select Picture.

http://img510.imageshack.us/img510/3...wertransfe.gif

Edit your image in Paint if you need to move areas around, change colors, etc.




> On Friday, February 26, 2010 11:56 AM psychobug wrote:

> I have charted two learning curves... the curves are basically parallel with
> one another... one is just slightly higher than/above the other. I want to
> fill the area below the lower of the two curve with one color; the area above
> the higher of the two curves with a second color; and leave the area between
> the two curves without any color. How?
>
> The color fill button on my toolbar fills the entire plot area with one color.
>
> Thanks in advance, Elaine


>> On Friday, February 26, 2010 12:48 PM Luke M wrote:

>> You might check out this:
>>
>> http://peltiertech.com/Excel/Charts/format.html#XYArea
>>
>> Several ways of adding background fills.
>>
>> --
>> Best Regards,
>>
>> Luke M


>>> On Monday, December 13, 2010 5:09 PM Thad Ayres wrote:

>>> I'm posting this for others who may search for this in the future as I have.
>>>
>>>
>>>
>>> Most every discussion group ended up pointing to the same page. http://peltiertech.com/Excel/Charts/BackgroundFill.html It has very good info but I was looking for something quicker. I came up with the following low-tech method to create color bands behind the plot area.
>>>
>>>
>>>
>>> Create your plot as usual. Make sure your page zoom is at 100%. Press ALT+PrintScreen to copy Excel window to clipboard (Excel must be active window). Open Microsoft Paint. Press CTRL+V to paste screenshot. Move/clip image so you only have the plot area remaining.
>>>
>>>
>>>
>>>
>>>
>>> By agthad at 2010-12-13


>>>> On Monday, December 13, 2010 5:10 PM Thad Ayres wrote:

>>>> I'm posting this for others who may search for this in the future as I have.
>>>>
>>>>
>>>>
>>>> Most every discussion group ended up pointing to the same page. http://peltiertech.com/Excel/Charts/BackgroundFill.html It has very good info but I was looking for something quicker. I came up with the following low-tech method to create color bands behind the plot area.
>>>>
>>>>
>>>>
>>>> Create your plot as usual. Make sure your page zoom is at 100%. Press ALT+PrintScreen to copy Excel window to clipboard (Excel must be active window). Open Microsoft Paint. Press CTRL+V to paste screenshot. Move/clip image so you only have the plot area remaining.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> By agthad at 2010-12-13


>>>> Submitted via EggHeadCafe
>>>> JQuery Templates and the Topsy Otter Twitter Search API
>>>> http://www.eggheadcafe.com/tutorials...earch-api.aspx