Automatic updating of excel tables in powerpoint slides

3 - If you do use the Chart sheet approach, make sure the option (Tools, Options, Chart, "Chart sizes with window frame" is NOT checked. 4 - Alright you say, but I got my data on the worksheet, the only way I can make sure the chart makes sense is when I see the chart next to the data (a someone valid argument).

So make the chart on the chart sheet (didn't we just agree on that? Select the entire chart on the chart sheet and copy and paste it to the worksheet near the data range.

If the chart was created at a zoom factor of "x" and the zoom factor of the worksheet is set to other than "x" when the file is saved and closed, then Excel linked charts will resize on you.When data in Excel changes, you can either update the charts on command or have think-cell do the update automatically.For a step-by-step guide on how to create a chart from your Excel data using think-cell, please consider the example from Introduction to charting.Now, that upper left hand corner is always "visible" to the linking mechanism during update links since a chart sheet is 100% "visible".Now a worksheet may not be 100% "visible" if you stuck the charts all over the place in a worksheet.

Leave a Reply