2003 "Pattern" fill effect
 

I am now using Excel 2007. Excel 2003 had a format data series fill effect
of "Pattern". It allowed selection of various line and dot patterns for a
stacked bar chart for example. I can't find this "Pattern" data series fill
effect in Excel 2007. Has it been removed? Thanks!

2003 "Pattern" fill effect
 

Hi,

The UI has been removed but via code it is still possible to set the
patterns.
I have an addin which provides a UI in xl2007
http://www.andypope.info/charts/patternfills.htm

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jim Orson" wrote in message
...
I am now using Excel 2007. Excel 2003 had a format data series fill effect
of "Pattern". It allowed selection of various line and dot patterns for a
stacked bar chart for example. I can't find this "Pattern" data series
fill effect in Excel 2007. Has it been removed? Thanks!

2003 "Pattern" fill effect
 

Hi Andy,
Works perfectly, many thanks!
Jim...

"Andy Pope" wrote in message
...
Hi,

The UI has been removed but via code it is still possible to set the
patterns.
I have an addin which provides a UI in xl2007
http://www.andypope.info/charts/patternfills.htm

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jim Orson" wrote in message
...
I am now using Excel 2007. Excel 2003 had a format data series fill
effect of "Pattern". It allowed selection of various line and dot
patterns for a stacked bar chart for example. I can't find this "Pattern"
data series fill effect in Excel 2007. Has it been removed? Thanks!

2003 "Pattern" fill effect
 

They removed it, but Andy Pope has an add-in that restores it:

http://andypope.info/charts/patternfills.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim Orson" wrote in message
...
I am now using Excel 2007. Excel 2003 had a format data series fill effect
of "Pattern". It allowed selection of various line and dot patterns for a
stacked bar chart for example. I can't find this "Pattern" data series
fill effect in Excel 2007. Has it been removed? Thanks!