Dynamic dashboards in PowerPoint 4Dashboards are great to visualize information. Think about the dashboard in a car. The speedometer there immediately gives a graphical indication of the speed. In a glance the user will see if driving too fast.

Link for dynamic data

The user can create similar digital dashboards to visualize the sales or production figures. Create an information screen or notice board with a speedometer or gauge in a Microsoft PowerPoint presentation and link it to an Excel file or database for real-time updating. As soon as a new order is added to the sales database, the gauge will update accordingly.

We use DataPoint to connect information screens to data sources. The user can use an Excel file or various database types to store the data. To learn how the user can connect to Excel read this article. For database linking refer to this article. Finally the user  end up with a data table with information that the user wants to show on the information screens.

Self-rotating needle

Let me show how the user can use a gauge or meter and update the needle at runtime.  First I create or open a presentation with a gauge. Then I select the needle of the gauge only.

rotate the needle of this meter in real time on your slide

And click DataPoint and Meter.

open dynamic dashboard or meter options in powerpoint menu

The connection is set to the data table that the user have in memory. Then the user selects the column and row of the cell containing the numeric value that the user wants to display.

link the rotation, height or width of the dashboard shape to your data source

Note that in PowerPoint the user can rotate a shape. In our example the needle needs to be rotated and typical for a rotation is that the user turns the shape in 360 degrees. So the value returned from the database should be converted into degrees. The number that represents the rotation is completely depending on the graphics of the gauge. Important in this calculation is the position (in degrees) of the starting point (0) and the position of the end point or maximum value.

example of multiple dynamic gauges in powerpoint

For the gauges shown here the starting point or minimum value is at -90 degrees and the ending point or maximum value is at 90 degrees. So when no sales were generated today, the needle rotates and points exactly to -90 degrees.

To catch extreme values of the database, the user can set a minimum physical value and a maximum value. When the highest possible value of the gauge is 100 and the user would have an exceptional database value of 120, then the user can set the maximum physical value to 100 to indicate that the meter has reached the top and will not rotate further than the maximum value of the gauge. At this situation, the car is already driving the maximum speed.

Other dynamic dashboard shapes

But sometimes the user don’t want to use needles and rotations. Now, the user can create a meter with a slider or thermometer to indicate the value like in this screenshot.

dynamic dashboard meter with dynamic width of the shape

Data Driven Presentations For You

Free PowerPoint Template

Download your free data driven PowerPoint templates
Use DataPoint to link presentations to various data sources
Great Digital Signage software for playlists with images, videos and PowerPoint presentations
Download FREE PowerPoint Templates

Download FREE PowerPoint Templates

You will receive more than 10 PowerPoint templates that you can use to create your information screens and digital signage.

You will also be asked if you want to be added to our mailing list to receive the latest resources, "how-to" articles and updates from our team.

You are subscribed successfully! You will get the gift with free Microsoft PowerPoint templates in your final subscription confirmation mail.

Pin It on Pinterest

Share This