Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / May 2008

Tip: Looking for answers? Try searching our database.

2003 "Pattern" fill effect

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jim Orson - 06 May 2008 16:23 GMT
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 - 06 May 2008 16:28 GMT
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!
Jon Peltier - 06 May 2008 19:50 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.