Create multiple series charts with Spreadsheets

In this article we'll show you how to use our Spreadsheets data source to add multiple series of data to visualizations within your Geckoboard dashboard. The options you have are the Line chart or the Column chart, which are able to display multiple series of data.examples of a multi-series line chart and column chart in Geckoboard

Video tutorial

Create a multi-series line chart

  1. After connecting your spreadsheet to Geckoboard, click drag cells to select a date range. Alternatively, you can select an entire row and column.click drag to select the date range you want to visualize
  2. To select another range of the spreadsheet, click the + button to the right of the field. Now select each data range you want to compare.click drag to select each data range you want to visualize
  3. When you're happy with your selection, click > Confirm selection.
  4. You'll now see highlighted visualization options. Click the + button that replaces the Line chart icon to select.

    By default, Geckoboard reads the data in columns. If your data series is arranged in rows, click the check box next to Transpose columns into rows.
  5. 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 a multi-series column chart

  1. After connecting your spreadsheet to Geckoboard, click drag cells to select the data range you want to include in your visualization.click drag to select the data range you want to visualize
  2. When you're happy with your selection, click > Confirm selection.
  3. You'll now see highlighted visualization options. Click the + button that replaces the Column chart icon to select.

    By default, Geckoboard reads the data in columns. If your data series is arranged in rows, click the check box next to Transpose columns into rows.
  4. 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.
Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

We're ready to help, 24 hours a day, 5 days a week

Get support
  • Fernanda Customer Success Avatar

    Megan

    USA
  • Hariharan Customer Success Avatar

    Hariharan

    India
  • Fernanda Customer Success Avatar

    Yasmin

    Spain
  • Luis Customer Success Avatar

    Luis

    UK
  • Richard Customer Success Avatar

    Richard

    UK
  • Fernanda Customer Success Avatar

    Fernanda

    Brazil
  • Heather Customer Success Avatar

    Heather

    USA