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

Cartoons in PowerPoint Presentations: Conversation... Mark Anderson graduated with a music degree in 1997, but his first job involved selling screws! Finding a music career impractical, and the business...
Learn PowerPoint 2007: Change Major Unit of Y Axis... The significance of any chart lies in its ability to visually represent complex data as a trend that an audience can easily grasp. So if you create a ...
Communicate, Collaborate, Educate using PowerPoint... Duncan Peberdy has a wide experience of the AV industry gained over many years working with manufacturers, distributors and resellers, focusing on ...

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 ( 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.


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-2018, Geetesh Bajaj - All rights reserved.

since November 02, 2000