| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
| "Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
| Excel 2003 does not recognize "no fill" from older Excel | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
