If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|