MadeStone

Update a Think-Cell Chart Dynamically from Excel Data

Просмотры:
42
Дата загрузки:
05.12.2023 21:31
Длительность:
00:05:35
Категория:
Обучение

Описание

? 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!

Источники:

Рекомендуемые видео