Automatic updating of excel tables in powerpoint slides
When the source data for your data-driven charts is available in Excel, you can create charts directly from the Excel application.
There are other ways to get Excel data onto a slide, so why would you want an active Excel spreadsheet?If Power Point is not yet running, it starts automatically.Nevertheless it is possible to transpose the data source (see Transposing linked data).In addition to the data, some cells to the left and on top are reserved for category and series labels.
Let’s say that you’re presenting some results of your financial analysis and your boss asks, “How did you get those results? It just means that the process is less disruptive and more continuous, so it looks more professional.
Show me the spreadsheet.” You could switch to Excel, but it might be more slick to have it available in your Power Point presentation. Try out this unusual technique and see if you like it.