 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Fill 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 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 _______ > How can I get a bar chart to have lines or hatching? I only see the > picture > or texture option. thanks 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? > 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: [quoted text clipped - 11 lines] > > picture > > or texture option. thanks 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 _______ >I just found this thread and downloaded Andy Pope's "solution". Now how do >I [quoted text clipped - 18 lines] >> > picture >> > or texture option. thanks 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) > How can I get a bar chart to have lines or hatching? I only see the picture > or texture option. thanks I think that most agree that they really screwed up charting with 2007  SignatureRegards, Peo Sjoblom > Thanks. > That was a silly move to remove the option - not everyone prints in [quoted text clipped - 4 lines] >> picture >> or texture option. thanks |
Reply to this Message |
 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
|
©2008 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.