Create Geck-O-Meters using spreadsheets

The Geck-O-Meter is a gauge visualization most useful to quickly see a metric in comparison to defined minimum and maximum values.

The selection will take numeric data along with currency symbols and % signs.

Before you get started, in the top right of the Spreadsheets widget set up screen, use the Widget Selector to change the widget type to Geck-O-Meter.

The GIF below gives a demo of the following steps.

  1. Click in the Geck-O-Meter selection field and either type in a cell selection (e.g. B1:B11), or click and drag over the desired cells in the Spreadsheet Data area. As you do this, the cells will highlight and you’ll see a live preview of your Geck-O-Meter.

  2. You can add a goal in the Goal field at the left of the screen by typing in the goal number or selecting a particular cell from the Spreadsheet Data area. Grey shading will be added to your Geck-O-Meter below the goal line to reflect this.If the Geck-O-Meter selection field is equal to or greater than the goal, the goal figure will become green.

  3. You can add a Min and a Max value to your Geck-O-Meter by typing in the number or selecting a particular cell from the Spreadsheet Data area. If no Min and/or Max values are added, your Geck-O-Meter will calculate it automatically using the lowest and highest value in the series.
  4. Give your widget a title.

  5. Change the widget size from the default (1x1) to the appropriate size for your Geck-O-Meter.

  6. When you’re happy with your Geck-O-Meter, click the green Add to dashboard button from the bottom of the screen.

ⓘ  Note: The Geck-O-Meter uses the last value in the series (i.e. last value in the selection) as current value. Which is the value the needle will point at.

More ways to visualize your spreadsheets

Now that you’re familiar with how to create a Geck-O-Meter, read our dedicated guides to creating the different visualizations available.

  • Line Chart
    Plot multiple series of values and visualize these trends over a period.

  • Column Chart
    Plot a series of data as vertical columns, with the option for individual labels for each column and a goal field, which can be set to highlight values above a specific target.

  • Bar Chart
    Plots a series of data in a horizontal bar chart, with the option for individual labels for each column and a goal field, which can be set to highlight values above a specific target.

  • Number Widget
    Consists of a single number pulled from a specified cell. Enables you to visually compare two figures with 4 comparison visualizations:

    • Sparkline
      Displays a primary metric with a sparkline (a small line chart) below it.

    • Percentage
      Displays a primary metric with a percentage change value below it that compares the primary metric with a secondary number.

    • Number
      Displays a primary metric with a value change below it that is a calculation of the difference between the the primary metric and a secondary number.

    • Goal
      Displays a primary metric with a goal change below it that is a calculation of the difference between the the primary metric and a secondary number.

  • Leaderboard
    Consists of a ranked list of items, each with a label and an optional value.

  • Text
    Displays non-numerical data from a cell, or multiple cells, in a spreadsheet.

Was this article helpful?
👍

Thank you for your feedback!