Update a Think-Cell Chart Dynamically from Excel Data
Описание
? Learn how to make CEO-ready slide decks (FREE email course): https://slidescience.co/
? 500+ PowerPoint templates, graphics & icons pack: https://slidescience.co/pack
In this video, we learn how to connect Think-Cell, PowerPoint and Excel, so that your chart automatically updates when data in Excel updates.
To do this:
1. Set up your data in Excel, so that it's in the same format as Think-Cell data
2. Highlight all cells with the data, then click Insert, Elements, and select your chart
3. This will automatically open up PowerPoint, so now place the chart.
4. Set chart to update automatically, by clicking on the chart, then clicking the circular 'Update Automatically' icon
Please note that both PowerPoint and Excel will be open for the data to update automatically. If either program is closed, the data can be edited manually, and will automatically update when both programs are open.
Chapters:
0:00 Introduction
0:46 Structuring your data in Excel
2:35 Updating data
4:08 Adding new data
Don't forget to subscribe to get my latest PowerPoint and Think Cell tips!
Рекомендуемые видео



















