Microsoft Office Tutorials and References
In Depth Information
Linking Your Excel Dashboards to PowerPoint
➤ Inserting new worksheets or chart sheets
➤ Moving or copying worksheets to another workbook
➤ Displaying the source data for a cell in a pivot table Values area or displaying pivot table
Filter pages on separate worksheets
➤ Creating a scenario summary report
➤ Using an Analysis ToolPak utility that requires results to be placed on a new worksheet
➤ Recording new macros
Choosing Windows prevents users from changing, moving, or sizing the workbook windows while
the workbook is opened.
Linking Your Excel Dashboards to
You may find that your organization heavily favors PowerPoint presentations for periodic updates.
Several methods exist for linking your Excel dashboards to a PowerPoint presentation. For current
purposes, we focus on the method that is most conducive to presenting frequently updated
dashboards and reports in PowerPoint — creating a dynamic link . A dynamic link allows your
PowerPoint presentation to automatically pick up changes that you make to data in your Excel
This technique of linking Excel charts to PowerPoint is ideal if you aren’t proficient at
building charts in PowerPoint. Build the chart in Excel and then create a link for the
chart in PowerPoint.
Creating the link between Excel and PowerPoint
When you create a link to a range in Excel, PowerPoint stores the location information to your source
field and then displays a representation of the linked data. The net effect is that when the data in
your source file changes, PowerPoint updates its representation of the data to reflect the changes.
You can find the example Chapter 19 Samples.xlsx file for this chapter on this topic’s
companion website at www.wiley.com/go/exceldr .
On the Web
To test this concept of linking to an Excel range, follow these steps:
1. Open the Chapter 19 Samples.xlsx file.
2. Click the chart to select it and press Ctrl+C on your keyboard to copy the chart.