Automatic updating of excel charts in powerpoint slides

In this article Add a Standard Module to a Power Point Presentation Add the Code to the Visual Basic Editor Test the Solution Next Steps Published: March 2011 Provided by: Frank Rice, Microsoft Corporation Microsoft Office 2010 includes a powerful and versatile charting engine.

If Power Point is not yet running, it starts automatically.

To complete this task, you must do the following: In this task, you add programming code that creates the simple chart with a small amount of data and then adds data to the chart.

Note that the procedures in this topic work with a Power Point 2010 presentation.

This is how the example chart data looks in Excel: To create a chart from Excel, select the desired data range in your Excel workbook, including series and category labels: The layout of your data must match the layout of think-cell’s internal datasheet: Column charts are usually created from data columns, whereas bar charts are created from data rows.

Nevertheless it is possible to transpose the data source (see Transposing linked data).


Leave a Reply