Create gauge widgets from spreadsheets

This guide walks you through the various options available when creating gauge widgets from your spreadsheet data.

Select data for your gauge widget

Select a single numeric cell from your connected spreadsheet. When you're happy with your selection, click Create visualization.

Edits to your source spreadsheet

If you need to make any edits to your spreadsheet you can manually refresh it from the bottom left corner of the screen. For example, you might need to remove currency or other symbols from your numeric data to avoid errors – you can always add these when you format your widget later.

From the bottom left corner, you can also switch to a different sheet.change the sheet by clicking in the bottom right corner

If your source spreadsheet is large and complex you might benefit from extracting the data you need to another spreadsheet specifically for powering your dashboard widgets. For more information, see preparing your spreadsheet for Geckoboard.

Preview your gauge widget

Next, you'll see highlighted visualization options for your selection. Click the gauge icon. In the bottom corner a preview shows how your widget will look.

To select a different cell, hover over the spreadsheet and click to edit selection.

When you're happy with your selection, click Continue >.

Configure your gauge widget

Visualization type

The visualization picker allows you to switch between the available options.Widget config for gauges built with spreadsheets

Visualization options

Add a Min and a Max value to your gauge. If no Min and/or Max values are added, your gauge will calculate it automatically using the lowest and highest value the selected data range.

Add status indicators

Adding success and/or negative values to your gauge widgets allows you to draw attention to changes as they happen.

Formatting

The Formatting menu allows you to overrule the automatically set number of decimal places used, or add additional information about the values on your widget. For more information, see our guide to using the data formatting options.

Add dynamic selection

The Dynamic selection menu enables you expand your initial single cell selection to a whole column or row. Your gauge widget will always display the last numeric value added.

For example, you could create this CSAT score gauge by using a dynamic selection, where the last available value (95) from the CSAT column will be visualized.gauge widget You can also customize your gauge with status indicators and using a % suffix. Formatting your spreadsheet for a gauge

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.