All Collections
Connect your spreadsheets
Build widgets from spreadsheets
Create multiple series charts using spreadsheets
Create multiple series charts using spreadsheets

Learn how to add multiple series of data to line and column charts using data from spreadsheets.

Updated over a week ago

Add multiple series of data to line and column charts using data from spreadsheets.

examples of a multi-series line chart and column chart in Geckoboard

Video tutorial

Create multi-series line chart widgets

  1. After connecting your spreadsheet to Geckoboard, click drag to select the cells you want to visualize.
    โ€‹
    Line chart widgets require at least:

    • 1 date, string (for X-axis labels) or numeric column

    • 1 other numeric column

    click drag to select each data range you want to visualize
  2. Next, you'll see highlighted visualization options for your selection. Click the line chart icon to preview how your line chart widget will look. When you're happy with your selection, click Continue >.
    โ€‹
    By default, Geckoboard reads the data in columns. If your data series is arranged in rows, click Switch rows and columns.

  3. Now you'll next see the widget configuration screen and a preview showing the multiple series in your line chart.

    configure your multi-series line chart

    On this screen you'll be able to add goal targets, status indicators, comparison visualizations, and any additional formatting information about the data being displayed.

Create multi-series column chart widgets

  1. After connecting your spreadsheet to Geckoboard, click drag to select the cells you want to visualize.
    โ€‹
    Column chart widgets require at least:

    • 1 date, string or numeric column

    • 1 other numeric column

    click drag to select the data range you want to visualize
  2. Next, you'll see highlighted visualization options for your selection. Click the column chart icon to preview how your column chart widget will look. When you're happy with your selection, click Continue >.
    โ€‹
    By default, Geckoboard reads the data in columns. If your data series is arranged in rows, click Switch rows and columns.

  3. Now you'll next see the widget configuration screen and a preview showing the multiple series in your column chart.

    configure your multi-series line chart

    On this screen you'll be able to add goal targets, status indicators, comparison visualizations, and any additional formatting information about the data being displayed.

Did this answer your question?