| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Options for 2007 Excell Chart
How can I get a bar chart to have lines or hatching? I only see the picture
or texture option. thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill Options for 2007 Excell Chart
You can't do this natively in 2007, but they left in the VBA hooks. Andy
Pope has an add-in that uses those hooks to apply patterns: http://www.andypope.info/charts/patternfills.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Watson" wrote in message ... How can I get a bar chart to have lines or hatching? I only see the picture or texture option. thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill Options for 2007 Excell Chart
Thanks.
That was a silly move to remove the option - not everyone prints in colour - the lines/hatching are so much better (and the textures are useless) "Watson" wrote: How can I get a bar chart to have lines or hatching? I only see the picture or texture option. thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill Options for 2007 Excell Chart
I think that most agree that they really screwed up charting with 2007
-- Regards, Peo Sjoblom "Watson" wrote in message ... Thanks. That was a silly move to remove the option - not everyone prints in colour - the lines/hatching are so much better (and the textures are useless) "Watson" wrote: How can I get a bar chart to have lines or hatching? I only see the picture or texture option. thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill Options for 2007 Excell Chart
I just found this thread and downloaded Andy Pope's "solution". Now how do I
get it to be available for all workbooks, even the one I started with. It is not saved so I have to keep reinstalling the add-in. Am I doing something wrong? "Jon Peltier" wrote: You can't do this natively in 2007, but they left in the VBA hooks. Andy Pope has an add-in that uses those hooks to apply patterns: http://www.andypope.info/charts/patternfills.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Watson" wrote in message ... How can I get a bar chart to have lines or hatching? I only see the picture or texture option. thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill Options for 2007 Excell Chart
Have you actually installed it as an add-in? Once you've done this is should
remain available for all workbooks, across sessions of Excel. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "vtwoods" wrote in message ... I just found this thread and downloaded Andy Pope's "solution". Now how do I get it to be available for all workbooks, even the one I started with. It is not saved so I have to keep reinstalling the add-in. Am I doing something wrong? "Jon Peltier" wrote: You can't do this natively in 2007, but they left in the VBA hooks. Andy Pope has an add-in that uses those hooks to apply patterns: http://www.andypope.info/charts/patternfills.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Watson" wrote in message ... How can I get a bar chart to have lines or hatching? I only see the picture or texture option. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell 2007 version. Shpe fill options | Excel Discussion (Misc queries) | |||
| How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
| Excel 2007 Chart Options | Excel Discussion (Misc queries) | |||
| Excel 2007 column chart fill question | Charts and Charting in Excel | |||
| Fill an area between 2 curves in an Excell chart? | Charts and Charting in Excel | |||
Linear Mode
