I have just upgraded from Excel 2003 to Excel 2007. In 2003, I could apply a
gradient fill to the plot area of a chart by selecting my own colours. 2007
just seems to offer a number of preset colours. Does anyone know if it is
possible to apply your own clours to gradient fill in 2007?

Many thanks,

Geoff

Microsoft removed this feature; maybe someone read Tufte's book?
However, Andy has given us a very useful macro to make patterns. Visit
http://www.andypope.info/charts/patternfills.htm
It is very easy to install and use.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Geoff Budd" <(E-Mail Removed)> wrote in message
news:5ED5B556-343E-4BDA-86A3-(E-Mail Removed)...
>I have just upgraded from Excel 2003 to Excel 2007. In 2003, I could apply
>a
> gradient fill to the plot area of a chart by selecting my own colours.
> 2007
> just seems to offer a number of preset colours. Does anyone know if it is
> possible to apply your own clours to gradient fill in 2007?
>
> Many thanks,
>
> Geoff

Hi,

If you are talking about gradient fills rather than the Pattern fills
Bernard mentions then you can use your own colours via the controls below
the Pre defined gradients.
You set the number of stops and the colour to use at each.

This is for smart art but the approach should be the same
http://office.microsoft.com/en-gb/ex...365991033.aspx

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Geoff Budd" <(E-Mail Removed)> wrote in message
news:5ED5B556-343E-4BDA-86A3-(E-Mail Removed)...
>I have just upgraded from Excel 2003 to Excel 2007. In 2003, I could apply
>a
> gradient fill to the plot area of a chart by selecting my own colours.
> 2007
> just seems to offer a number of preset colours. Does anyone know if it is
> possible to apply your own clours to gradient fill in 2007?
>
> Many thanks,
>
> Geoff

> maybe someone read Tufte's book?

Sure they read it. Did they apply any of it?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Bernard Liengme" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Microsoft removed this feature; maybe someone read Tufte's book?
> However, Andy has given us a very useful macro to make patterns. Visit
> http://www.andypope.info/charts/patternfills.htm
> It is very easy to install and use.
> best wishes
> --
> Bernard V Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme
> remove caps from email
>
> "Geoff Budd" <(E-Mail Removed)> wrote in message
> news:5ED5B556-343E-4BDA-86A3-(E-Mail Removed)...
>>I have just upgraded from Excel 2003 to Excel 2007. In 2003, I could
>>apply a
>> gradient fill to the plot area of a chart by selecting my own colours.
>> 2007
>> just seems to offer a number of preset colours. Does anyone know if it
>> is
>> possible to apply your own clours to gradient fill in 2007?
>>
>> Many thanks,
>>
>> Geoff
>
>

Thanks Andy. The "stops" seem to be the answer. I obviously had not
experimented enough!

Geoff

"Andy Pope" wrote:

> Hi,
>
> If you are talking about gradient fills rather than the Pattern fills
> Bernard mentions then you can use your own colours via the controls below
> the Pre defined gradients.
> You set the number of stops and the colour to use at each.
>
> This is for smart art but the approach should be the same
> http://office.microsoft.com/en-gb/ex...365991033.aspx
>
> Cheers
> Andy
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "Geoff Budd" <(E-Mail Removed)> wrote in message
> news:5ED5B556-343E-4BDA-86A3-(E-Mail Removed)...
> >I have just upgraded from Excel 2003 to Excel 2007. In 2003, I could apply
> >a
> > gradient fill to the plot area of a chart by selecting my own colours.
> > 2007
> > just seems to offer a number of preset colours. Does anyone know if it is
> > possible to apply your own clours to gradient fill in 2007?
> >
> > Many thanks,
> >
> > Geoff
>
>