A Complete Guide to Data Driven Charts In PowerPoint скачать в хорошем качестве

A Complete Guide to Data Driven Charts In PowerPoint

Today I will show you how you can create data driven charts in Microsoft PowerPoint with the DataPoint add-on. These charts are linked to data and are updated automatically when you just open the presentation. Or you can run the slide show on a computer screen and see real-time updates while you are presenting. I got this nice looking PowerPoint template from my friends at www.PresentationLoad.com. We will use 1 slide only for now and I will remove all the other slides. I want to link the chart of this first slide, to my data in an Excel file. Here is my Excel with some data; I have some sales information on products for multiple years. This I want to show in my data driven chart. Now I will use the DataPoint add-on for PowerPoint. I click the List button of the Connections. I navigate to Excel here and click the Add Connection button. Now I browse and select my Excel data file. And I name my connection. Now I click Add Query and instruct DataPoint to read the information of Sheet1. The range I need for this is A1:F5 and I will use a data refresh rate of 1 second. So every second, DataPoint will scan the Excel file for new data. OK to close. I set an optional name on this query and I see the data already here in this preview area. Now I select the chart and click the Chart button at the DataPoint menu. There is only one usable connection in this presentation, so I just click OK and accept the default settings like so. And now all current data of my Excel file is copied into the PowerPoint. You see the years have changed, the products were updated and of course the data. Now let me run this in slide show mode. This goes on the left area of my screen. And then this Excel data file on the right. You can now update the information in the Excel document and everything is updated in real-time in your PowerPoint presentation. This now runs locally, but you can run this data driven chart on a dedicated machine and monitor and update the excel file from another computer. More information at www.presentationpoint.com/software/datapoint/ ✅PLEASE SUBSCRIBE AND PRESS THE BELL🔔ICON➡️https://bit.ly/3gXDuV1 ✅VISIT OUR WEBSITE➡️https://www.presentationpoint.com/ ✅BUSINESS QUERIES➡️info@presentationpoint.com ✅Download Free PowerPoint Digital Signage templates: https://www.presentationpoint.com/tem... ✅Access our Free online course: "How to Use PowerPoint for Digital Signage" https://presentationpoint.usefedora.c... 🎬CHECK OUT OUR POPULAR VIDEOS:👇 ▶️How to work with multiple users on an Excel worksheet?➡️   • How to work with multiple users on an Exce...   ▶️How to link PowerPoint to Excel for dynamic data updates?➡️   • How to link PowerPoint to Excel for dynami...   ▶️Digital Menu Boards Created Easily using PowerPoint➡️   • Digital Menu Boards Created Easily using P...   ▶️Mail merging Excel information into PowerPoint presentation➡️   • Mail merging Excel information into PowerP...   ▶️How to run a live countdown timer in PowerPoint➡️   • How to run a live countdown timer in Power...   🤝STAY CONNECTED WITH US:👇 ✅  / presentationpoint   ✅  / presentationpnt   ✅  / 3500848   ✅https://www.presentationpoint.com/feed/ #PresentationPoint #powerpoint #excel #word #presentation #microsoft #powerpointpresentation #office #ppt #business #microsoftexcel #design #accounting #amazingslidepresentation #slides #digitalsignage #powerpointdesign #slidedesigner #livepowerpoint #slidepowerpoint #marketing #presentationdesign #mailmerge #screen_savers #Promoting_Online_Courses #PowerPoint_for_Digital_Signage #Coronavirus #Automating_PowerPoint_from_Excel #Google_Analytics_data #KPI_dashboards #PowerPoint_Salesforce_integration #One_World_Observatory #Merge_PowerPoint_Presentations #Mind_blowing_PowerPoint #Digital_Signage