Quick Note Scenario: Working Programmatically with Office 2010 Charts

Programmatically Working with Office 2010 Charts: Learn how to programmatically create and manipulate charts.

Applies to: Excel 2010 | Office 2010 | PowerPoint 2010 | VBA | Word 2010

In this article
Next Steps
Additional Resources
About the Author

Published:   March 2011

Provided by:    Frank Rice, Microsoft Corporation

Quick Notes are 2-4 page tasks in a single scenario. Combined, they provide an end-to-end solution for a specific scenario. Individually, they are single-page tasks that you can print and use.

The goal of these exercises is to enable you to customize Microsoft Office 2010 for your own applications. Each task addresses a particular scenario. After you complete an exercise, you should have a good understanding of how to apply the information to your own solutions.

Next Steps

To implement this scenario, complete the following tasks:

• Changing Chart Location in Office 2010

• Manipulating Data Points in a Chart in Office 2010

• Manipulating Properties of a Chart Series in Office 2010

• Modifying Chart Axes Text in Office 2010

• Modifying Chart Legends in Office 2010

• Modifying Chart Styles in Office 2010

• Modifying Chart Titles in Office 2010

• Programmatically Create a Chart in Office 2010

• Update Chart Data

• Working with Excel Data Bars

• Working with Sparkline Properties in Office 2010

• Additional Resources

• About the Author

Additional Resources

• Office Developer Center on MSDN

• Creating Charts with VBA in Word 2010

• Office Chart Object Model in PowerPoint and Word

About the Author

Frank Rice, Microsoft Corporation, is a frequent contributor to the Microsoft Office Developer Center.