Create multiple series charts using spreadsheets

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

Create multi-series line chart widgets

  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 Create visualization.
  4. Next, you'll see highlighted visualization options for your selection. Click the line chart icon. In the bottom corner a preview shows how your 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.
  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 multi-series column chart widgets

  1. After connecting your spreadsheet to Geckoboard, click drag cells to select the data range you want to include in your visualization. You can select up to 5 data columns.click drag to select the data range you want to visualize
  2. When you're happy with your selection, click Create visualization.
  3. Next, you'll see highlighted visualization options for your selection. Click the line chart icon. In the bottom corner a preview shows how your 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.
  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.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.