Article ID: 948683 - View products that this article applies to.
You cannot use Microsoft Visual Basic for Application (VBA) to modify a chart that you have inserted in Microsoft Office PowerPoint 2007 or Office Word 2007.
Note You can use VBA modify a chart that you insert in earlier versions of PowerPoint.
In Microsoft Office PowerPoint 2007 or in Office Word 2007, the chart object model (OM) is no longer available in Microsoft Visual Basic for Application (VBA).
To resolve this issue, install 2007 Office Suite Service Pack 2. After you install 2007 Office Suite Service Pack 2, you can use Microsoft Visual Basic for Application (VBA) to modify a chart that you have inserted in PowerPoint 2007 or Word 2007. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/953195/ )Description of the 2007 Microsoft Office Suite Service Pack 2 and Microsoft Office Language Pack 2007 Service Pack 2
To work around this issue, use VBA in Excel to modify the inserted chart. Then, paste the chart from Excel into PowerPoint 2007 or Word 2007 by using the VBA Automation techniques.
For more information about Office Chart Object Model in PowerPoint and Word, visit the following Microsoft Web site:
This change to Microsoft Office PowerPoint 2007 and Word 2007 is a known limitation.
Contact us for more help
Connect with Answer Desk for expert help.