Charts and Widgets for Dashboards

Dashboard Charts and Widgets allow you to visualize your data in real-time so that you can make smarter and better decisions faster. Charts are a widget type on a dashboard and pull directly from your sheets and reports to display trends and key performance indicators in your live data.

In this tutorial, we’ll show you how to make stunning live widgets using our professional chart add-in.

How to Create and edit Charts and Widgets?

Steps to create live widgets

  1. Click on the chart icon on the ribbon
  2. Add a name for the widget
  3. Add zones (if it’s necessary) and choose your preferred color for zones
  4. Browse the cells which contain actual value and description.
  5. Click Create to insert a new chart.

You can also check in motion how it’s work.

create gauge chart widgets

Download the free speedometer widget!

How to manage your dashboard widgets?

how to edit charts and widgets?
  1. Click on the chart icon to start the userform again.
  2. Modify the skin, font size, add or remove zones, change the default colors.
  3. Finally, click on the update button.

Advanced Dashboard Chart types for Developers

Dual Gauge Charts

If you want to display the differences between plan and actual values, we recommend using Dual Gauge chart widget. It’s a little bit unusual way in Excel but provide stunning visualization possibilities.

The method (create and manage) as same as the first example above.

dual gauge example

Traffic Light Widgets

Project status tracking using traffic lights? No problem. We have created live charts to measure your PM-related indicators. Using this user-friendly interface you can connect your data easily. We love the red-amber-green style, and you can identify the actual status of your metrics asap.

Radial Bar Chart

With the radial bar chart, you can create awesome dashboards. Each bar appears in a circle with longer bars representing larger values. If you vote for infographics-style, this graph is yours!

Steps to create radial bar graph:

  1. Select the range which contains Names, Upper Limits and Colors (3 columns)
  2. Click on the Bullet chart icon on the Ribbon.
  3. Use the drop-down menu to select the chart type (vertical or horizontal)
  4. Click OK, and it’s done.
radial bar chart

Bullet Graph Widget

Bullet graph provides an alternative for gauges. The bullet graph displays a single value and compares that measure to one or more other measures to highlight the overall performance (for example bad, poor, average, good).

Don’t forget: If you have not enough free space in your chart area this widget type can be really helpful.

create bullet graph widget

Score Meter

Would you like to create a linear speedometer style graph? We are a fan of using gauges and bullet graphs, but in some cases it’s necessary to use something else.

Score meter (rating meter) is a space-saving solution and could be an effective way to represent data when you have the actual value and the target value.

Just three easy steps are necessary to create the score meter. Select the range which contains the initial data set, click on the chart icon on the ribbon, finally click OK to insert the widget.

score meter charts dashboards widgets

Variance Chart Widgets

Create horizontal or vertical variance graph in a single click. Highlight the initial data range and click the given chart icon on the ribbon. We only need to highlight the plan and actual data rows.

Final Thoughts

If you are in a hurry, we strongly recommend using automated solutions. You can save time and boost your productivity.

Additional resources

How to create a dashboard in Excel?