Chart Pattern Fills Add-in: Conversation with Andy Pope

Created: Wednesday, December 3, 2008, posted by Geetesh Bajaj at 4:47 am



Andy PopeAndy Pope (pictured to the right) works in London, UK, developing in-house reporting systems. He uses VBA to automate Excel and PowerPoint. In his spare time, he frequents various Excel forums and maintains his own website on Excel charting. His contributions to the Excel community have resulted in him being awarded as Microsoft Excel MVP since 2004.

In this discussion, Andy discusses the Chart Pattern Fills add-in for Excel 2007.

Geetesh: Tell us more about your Chart Pattern Fills add-in for Excel 2007, and what motivated you to create this add-in.

Andy: I developed the add-in in response to posts by users who need the pattern fills feature that was depreciated in Excel 2007. Apparently pattern fills are heavily used by those in academia. I was aware that actually only the user interface for the feature had been removed so I went about reconstructing the Patterns dialog. I enjoyed the challenge of creating a dialog that would dynamically reflect the users color choices, rather than just using static images.

It’s a totally free add in and available on my site.

Chart Pattern Fills add-in for Excel 2007

Geetesh: PowerPoint 2007 users also no longer have access to the pattern fills so will this add-in work for them too?

Andy: Unfortunately not directly within PowerPoint. The porting of the add-in to PowerPoint is not currently possible. This is due to limitations in PowerPoint’s VBA Object Model and how the add-ins function works compared to those in Excel. As and when/if Microsoft make appropriate changes I will attempt to make a PowerPoint version.

In the mean time for those wanting to use the add-in, you can create their chart in Excel, format it as required using the add-in and then insert the saved file as an Object within PowerPoint.

See Also: Pattern Fills Add-in: Conversation with John Wilson

Categories: add-in, charting, excel, powerpoint

Related Posts

PowerPoint Ezine: Issue 74 This is one of the best ezine issues ever! You get three giveaways put together -- for Balesio's PPTMinimizer 3, Wildform's WildPresenter 3, and an a...
iPad for Presenter’s View in PowerPoint: Conversat... A refugee from 18 years in corporate management and marketing, Rikk Flohr turned his attention inward to his 20-year love affair with photography. He...
Five Tips for Displaying Numbers on PowerPoint Sli... When presenting financial results on a PowerPoint slide, do not overwhelm your audience. Use the power of your numbers to support your conclusions. D...

Filed Under: Uncategorized
Tagged as: , , ,

1 Comment

  • Dear all,
    I recently wrote a small add-in for Powerpoint 2007 which enables you to apply pattern fills to PPT forms.

    The addin is available for download totally free of charge from my website (www.mschwarz.org). Currently it’s still in Beta version due to a lack of testing feedback.

    Let me know if the tool is helpful for, what you miss but also what you like.

    Markus

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Plagiarism will be detected by Copyscape

© 2000-2017, Geetesh Bajaj - All rights reserved.

since November 02, 2000