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!
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

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
>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!
Jim Orson - 06 May 2008 17:44 GMT
Hi Andy,
Works perfectly, many thanks!
Jim...
> Hi,
>
[quoted text clipped - 9 lines]
>>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!
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
_______
>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!