Create visualizations from your spreadsheets (B)

Once you've connected your Google Sheet or Excel file to Geckoboard, in this article you'll create visualizations from your spreadsheet data.

Before you start

We're currently testing two versions of our spreadsheets data source. To make sure the instructions are correct, please select the article that matches the user interface matches what you're seeing in Geckoboard. chooose which spreadsheets UI you can see

Configure visualizations from your spreadsheet

From the following visualization types listed below, click the one you want to configure.

Now, select the corresponding visualization type from in the top left of the Spreadsheets config screen.

number widget icon
gauge widget icon
line chart widget icon
column chart widget icon
bar chart widget icon
leaderboard widget icon
table widget icon
text widget icon

 

Number

With the number visualization selected, you'll be able to add status indicators, comparison visualizations, and any additional formatting information about the data being displayed. You'll see a preview of the widget as you create it.

Learn more with our introductory guide to the number visualization.

Select data from your spreadsheet

To select the data to visualize from your spreadsheet, follow these steps.

  1. Click drag to select the spreadsheet cells you want to visualize.click drag to select the cells you want to visualizeAlternatively, you can select entire rows and columns or enter the data range into the Number selection field.select whole columns you want to visualize
    If your data is found on a different sheet of your file you can select a different sheet by clicking the selector in the bottom left corner of your spreadsheet.

    To reflect any changes you've just made to your spreadsheet you can manually refresh it by clicking the downward arrow to the right of your spreadsheet name and clicking Reload spreadsheet.change the sheet by clicking in the bottom right corner

    Tip

    You can create dynamic visualizations that automatically update as you add new data to your spreadsheet.

    By including cells from columns or rows in your spreadsheet that you'll populate in the future, you won't need to return to extend your data range.

    This works particularly well with line charts, column charts and bar charts that use dates or datetimes for their axis labels. create dynamic visualizations by selecting cells you'll populate in the future

  2. When you're happy with your selection, you can either fine-tune your number widget, add a comparison visualization, or add status indicators.

Fine-tune

Click the Fine-tune tab to to change the number of decimal places used or add additional information about the value(s) being displayed on your number widget.formatting panel on the spreadsheets config screen

For more details, see our article on how to using the number formatting menu.

Comparison visualization

The number widget allows you to visually compare the primary metric with a choice of four comparison visualizations: goal, number, percentage, and sparkline.

Sparkline

Displays a sparkline (a very small line chart, typically drawn without axes or coordinates) of the values in the selected range (top to bottom or left to right). The more cells in your selected range, the more detailed your sparkline will be.spreadsheets number widget with a secondary sparkline viz

Percentage

Displays the percentage change from the your initial selected cell as a percentage. Click the up or down arrows to indicate whether an increased or deceased percentage change is good (displays in green).spreadsheets number widget with a secondary percentage change viz

Number

Displays the number change from your initial selected cell. Click the up or down arrows to indicate whether an increased or deceased change is good (displays in green).spreadsheets number widget with a secondary number change viz

Goal

Displays a goal progress bar below the primary metric.

Tracking goals creates a feeling of progression as you edge closer towards your targets. They are great for keeping a team motivated, particularly when working towards longer term objectives.spreadsheets number widget showing progress towards a goal

Enter your goal target value and, optionally, your starting value to define where your goal progress starts from.setting a goal target and a starting value

Status indicators

Adding status indicators allows you to call attention to your number widget on your dashboard when it's performing above and below expectations. Status indicators will overwrite any goals you set on this widget.status indicators panel on the spreadsheets config screen

By setting a Warning value, when the primary metric is above or below the warning value your widget to turn red.

By setting a Success value, when the primary metric is above or below the success value your widget instead turns green.

For more details, see our article on how to add status indicators to number widgets.

Gauge

With the gauge visualization selected, you'll be able to add status indicators and any additional formatting information about the data being displayed. You'll see a preview of the widget as you create it.

Learn more with our introductory guide to the gauge visualization.

Select data from your spreadsheet

To select the data to visualize from your spreadsheet, follow these steps.

  1. Click drag to select the spreadsheet cells you want to visualize.click drag to select the cells you want to visualizeAlternatively, you can select entire rows and columns or enter the data range into the Number selection field.select whole columns you want to visualize
    If your data is found on a different sheet of your file you can select a different sheet by clicking the selector in the bottom left corner of your spreadsheet.

    To reflect any changes you've just made to your spreadsheet you can manually refresh it by clicking the downward arrow to the right of your spreadsheet name and clicking Reload spreadsheet.change the sheet by clicking in the bottom right corner

    Tip

    You can create dynamic visualizations that automatically update as you add new data to your spreadsheet.

    By including cells from columns or rows in your spreadsheet that you'll populate in the future, you won't need to return to extend your data range.

    This works particularly well with line charts, column charts and bar charts that use dates or datetimes for their axis labels. create dynamic visualizations by selecting cells you'll populate in the future

  2. 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.
  3. When you're happy with your selection, you can either fine-tune your gauge widget or add status indicators.

Fine-tune

Click the Fine-tune tab to to change the number of decimal places used or add additional information about the value(s) being displayed on your gauge widget.formatting panel on the spreadsheets config screen

For more details, see our article on how to using the number formatting menu.

Status indicators

Adding status indicators allows you to call attention to your gauge widget on your dashboard when it's performing above and below expectations. status indicators panel on the spreadsheets config screen

By setting a Warning value, when the primary metric needle is above or below the red warning line that section of your gauge turns red.

By setting a Success value, when the primary metric needle is above or below the green success line the section of your gauge instead turns green.spreadsheets gauge widget with success and warning indicators

For more details, see our article on how to add status indicators to gauge widgets.

Line Chart

The line chart widget plots multiple series of values and visualizes these trends over a period. Line charts also have an optional goal field.

Learn more with our introductory guide to the line chart visualization.

Select data from your spreadsheet

To select the data to visualize from your spreadsheet, follow these steps.

  1. Click drag to select the spreadsheet cells you want to visualize.click drag to select the cells you want to visualizeAlternatively, you can select entire rows and columns or enter the data range into the Number selection field.select whole columns you want to visualize
    If your data is found on a different sheet of your file you can select a different sheet by clicking the selector in the bottom left corner of your spreadsheet.

    To reflect any changes you've just made to your spreadsheet you can manually refresh it by clicking the downward arrow to the right of your spreadsheet name and clicking Reload spreadsheet.change the sheet by clicking in the bottom right corner

    Tip

    You can create dynamic visualizations that automatically update as you add new data to your spreadsheet.

    By including cells from columns or rows in your spreadsheet that you'll populate in the future, you won't need to return to extend your data range.

    This works particularly well with line charts, column charts and bar charts that use dates or datetimes for their axis labels. create dynamic visualizations by selecting cells you'll populate in the future

  2. 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.
  3. When you're happy with your selection, you can either fine-tune your line chart widget, set a goal or min and max values for your Y-axis.

Fine-tune

Click the Fine-tune tab to to change the number of decimal places used or add additional information about the value(s) being displayed on your line chart widget.formatting panel on the spreadsheets config screen

For more details, see our article on how to using the number formatting menu.

Goal

Enter a goal value, then select whether the goal value is set for less than or more than.goal panel on the spreadsheets config screenGrey shading will be added to your line chart above the goal line to indicate the target area.spreadsheets line chart widget with goal area shaded in grey

Tip

If your column or row selection included pre-populated cells your line chart will now automatically respond as you add data to your connected Google Sheet or Excel workbook.spreadsheets line chart widget that shows how selecting pre-populated cells can create dynamic visualizations

Setting Y-axis Min and Max

Enter minimum and maximum values for your line chart's Y-axis. Your line chart preview will change to reflect this.y-axis minimum and maximun panel on the spreadsheets config screen

Column Chart

Column charts allow you to plot a series of data into vertical columns, with optional labels for each column. Column charts also have an optional goal field which can be set to highlight values above a specific target.

Learn more with our introductory guide to the column visualization.

Select data from your spreadsheet

To select the data to visualize from your spreadsheet, follow these steps.

  1. Click drag to select the spreadsheet cells you want to visualize.click drag to select the cells you want to visualizeAlternatively, you can select entire rows and columns or enter the data range into the Number selection field.select whole columns you want to visualize
    If your data is found on a different sheet of your file you can select a different sheet by clicking the selector in the bottom left corner of your spreadsheet.

    To reflect any changes you've just made to your spreadsheet you can manually refresh it by clicking the downward arrow to the right of your spreadsheet name and clicking Reload spreadsheet.change the sheet by clicking in the bottom right corner

    Tip

    You can create dynamic visualizations that automatically update as you add new data to your spreadsheet.

    By including cells from columns or rows in your spreadsheet that you'll populate in the future, you won't need to return to extend your data range.

    This works particularly well with line charts, column charts and bar charts that use dates or datetimes for their axis labels. create dynamic visualizations by selecting cells you'll populate in the future

  2. 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.
  3. When you're happy with your selection, you can either fine-tune your column chart widget or add a goal.

Fine-tune

Click the Fine-tune tab to to change the number of decimal places used or add additional information about the value(s) being displayed on your column chart widget.formatting panel on the spreadsheets config screen

For more details, see our article on how to using the number formatting menu.

Goal

Enter a goal value, then select whether the goal value is set for less than or more than.goal panel on the spreadsheets config screenGrey shading will be added to columns that don't meet the goal to reflect this and any columns that meet the goal will turn green in color.spreadsheets column chart widget with goal area shaded in grey

Tip

Remember our tip about dynamic visualizations at the data selection stage? If your column or row selection included pre-populated cells your column chart will now automatically respond as you add data to your connected Google Sheet or Excel workbook.spreadsheets column chart widget that shows how selecting pre-populated cells can create dynamic visualizations

Bar Chart

Similar to column charts, but landscape. The bar chart widget plots a series of data into horizontal bars, with optional labels for each column. Bar charts also have an optional goal field which can be set to highlight values above a specific target.

Select data from your spreadsheet

To select the data to visualize from your spreadsheet, follow these steps.

  1. Click drag to select the spreadsheet cells you want to visualize.click drag to select the cells you want to visualizeAlternatively, you can select entire rows and columns or enter the data range into the Number selection field.select whole columns you want to visualize
    If your data is found on a different sheet of your file you can select a different sheet by clicking the selector in the bottom left corner of your spreadsheet.

    To reflect any changes you've just made to your spreadsheet you can manually refresh it by clicking the downward arrow to the right of your spreadsheet name and clicking Reload spreadsheet.change the sheet by clicking in the bottom right corner

    Tip

    You can create dynamic visualizations that automatically update as you add new data to your spreadsheet.

    By including cells from columns or rows in your spreadsheet that you'll populate in the future, you won't need to return to extend your data range.

    This works particularly well with line charts, column charts and bar charts that use dates or datetimes for their axis labels. create dynamic visualizations by selecting cells you'll populate in the future

  2. 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.
  3. When you're happy with your selection, you can either fine-tune your bar chart widget or add a goal value.

Fine-tune

Click the Fine-tune tab to to change the number of decimal places used or add additional information about the value(s) being displayed on your bar chart widget.formatting panel on the spreadsheets config screen

For more details, see our article on how to using the number formatting menu.

Goal

Enter a goal value, then select whether the goal value is set for less than or more than.goal panel on the spreadsheets config screenGrey shading will be added to bars that don't meet the goal to reflect this and any bars that meet the goal will turn green in color.spreadsheets bar chart widget with goal area shaded in grey

Tip

Remember our tip about dynamic visualizations at the data selection stage? If your column or row selection included pre-populated cells your bar chart will now automatically respond as you add data to your connected Google Sheet or Excel workbook.spreadsheets bar chart widget that shows how selecting pre-populated cells can create dynamic visualizations

Leaderboard

Leaderboards consist of a ranked list of items, each with a label and a value.spreadsheets leaderboard widget

Learn more with our introductory guide to the leaderboard visualization.

Select data from your spreadsheet

To select the data to visualize from your spreadsheet, follow these steps.

  1. Click drag to select the spreadsheet cells you want to visualize.click drag to select the cells you want to visualizeAlternatively, you can select entire rows and columns or enter the data range into the Number selection field.select whole columns you want to visualize
    If your data is found on a different sheet of your file you can select a different sheet by clicking the selector in the bottom left corner of your spreadsheet.

    To reflect any changes you've just made to your spreadsheet you can manually refresh it by clicking the downward arrow to the right of your spreadsheet name and clicking Reload spreadsheet.change the sheet by clicking in the bottom right corner

    Tip

    You can create dynamic visualizations that automatically update as you add new data to your spreadsheet.

    By including cells from columns or rows in your spreadsheet that you'll populate in the future, you won't need to return to extend your data range.

    This works particularly well with line charts, column charts and bar charts that use dates or datetimes for their axis labels. create dynamic visualizations by selecting cells you'll populate in the future

  2. 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.
  3. When you're happy with your selection, you can either fine-tune your leaderboard widget or, if needed, reverse the sort order.

Fine-tune

Click the Fine-tune tab to to change the number of decimal places used or add additional information about the value(s) being displayed on your leaderboard widget.formatting panel on the spreadsheets config screen

For more details, see our article on how to using the number formatting menu.

Reverse sort order

Toggle the switch to rank the leaderboard by lowest value first.

Tip: Use CONCATENATE for multiple columns

If the information you want to include about the ranked items in your leaderboard span multiple cells in your spreadsheet, you can use the CONCATENATE function. Available in Google Sheets and Excel, CONCATENATE enables you combine the contents of two or more cells into a third separate cell.

In our example, we want to add information about the sales team each rep belongs to. Column A lists the name of each rep, B includes a dash separator (to avoid a result like NathanRed), and C lists the team they belong to.google sheet showing example of concatentate function

For each cell in column D starting from A2, we'll use the formula =concatenate(A2, B2, C2) to return Nathan – Red. Now when you select Column D as part of your leaderboard's data selection you'll see your merged cells.spreadsheets leaderboard widget with merged columns using concatenate

Table

The Table widget is used to display data from up to 10 columns from a spreadsheet. You can also change the column order on your widget without having to edit your spreadsheet.

Select data from your spreadsheet

To select the data to visualize from your spreadsheet, follow these steps.

  1. Click drag to select the spreadsheet cells you want to visualize.click drag to select the cells you want to visualizeAlternatively, you can select entire rows and columns or enter the data range into the Number selection field.select whole columns you want to visualize
    If your data is found on a different sheet of your file you can select a different sheet by clicking the selector in the bottom left corner of your spreadsheet.

    To reflect any changes you've just made to your spreadsheet you can manually refresh it by clicking the downward arrow to the right of your spreadsheet name and clicking Reload spreadsheet.change the sheet by clicking in the bottom right corner

    Tip

    You can create dynamic visualizations that automatically update as you add new data to your spreadsheet.

    By including cells from columns or rows in your spreadsheet that you'll populate in the future, you won't need to return to extend your data range.

    This works particularly well with line charts, column charts and bar charts that use dates or datetimes for their axis labels. create dynamic visualizations by selecting cells you'll populate in the future

  2. 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.
  3. When you're happy with your selection, you can either fine-tune your table widget or, if needed, change the column order.

Fine-tune

Click the Fine-tune tab to to change the number of decimal places used or add additional information about the value(s) being displayed on your table widget.formatting panel on the spreadsheets config screen

For more details, see our article on how to using the number formatting menu.

Selection contains headers

Toggle this switch to treat the first row in your selection as the header.

Column order

In the config panel you'll see a list of your columns. Click drag each column to change the order that they'll appear on your widget.spreadsheets table widget can display up to 10 columns

Text

The Text widget is used to display non-numerical data from a cell, or multiple cells, from a spreadsheet.

If you're visualizing text from a spreadsheet for the sole purpose of displaying it in Geckoboard, you may want to try out our dedicated Text widget instead.

Select data from your spreadsheet

To select the data to visualize from your spreadsheet, follow these steps.

  1. Click drag to select the spreadsheet cells you want to visualize.click drag to select the cells you want to visualizeAlternatively, you can select entire rows and columns or enter the data range into the Number selection field.select whole columns you want to visualize
    If your data is found on a different sheet of your file you can select a different sheet by clicking the selector in the bottom left corner of your spreadsheet.

    To reflect any changes you've just made to your spreadsheet you can manually refresh it by clicking the downward arrow to the right of your spreadsheet name and clicking Reload spreadsheet.change the sheet by clicking in the bottom right corner

    Tip

    You can create dynamic visualizations that automatically update as you add new data to your spreadsheet.

    By including cells from columns or rows in your spreadsheet that you'll populate in the future, you won't need to return to extend your data range.

    This works particularly well with line charts, column charts and bar charts that use dates or datetimes for their axis labels. create dynamic visualizations by selecting cells you'll populate in the future

  2. When you're happy with your selection, click Add to dashboard.

Spreadsheet widgets refresh rate

Spreadsheet widgets automatically refresh within 3 minutes of a change being made to the sheet containing your data.

The exceptions to the above rule are visualizations powered by import formulas such as "IMPORTRANGE", "IMPORTDATA", etc. or by pivot tables, which automatically refresh every 15 minutes.

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.