2003 "Pattern" fill effect

[Jim Orson]

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!

 

[Andy Pope]

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

 

[Jim Orson]

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

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

 

[Jon Peltier]

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

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

- Jon