This guide walks you through the various options available when creating line chart widgets from your spreadsheet data.
Select data for your line chart widget
Line chart widgets require at least:
1 date, string (for X-axis labels) or numeric column
1 other numeric column
Click drag to select the spreadsheet cells you want to visualize. You can also select entire rows and columns or enter the data range into the field.
If your column or row selections include pre-populated cells your line chart will automatically respond as you add data to your connected Google Sheet or Excel workbook.
When you're happy with your selection, click Create visualization.
Refreshing your source spreadsheet
If you need to make any edits to your spreadsheet you can manually refresh it from the bottom left corner of the screen. From here you can also switch to a different sheet.
If your source spreadsheet is large and complex you might benefit from extracting the data you need to another spreadsheet specifically for powering your dashboard widgets. For more information, see preparing your spreadsheet for Geckoboard.
Preview your line chart widget
Next, you'll see highlighted visualization options for your selection. Click the line chart chart icon to preview how your line chart widget will look.
When you're happy with your selection, click Continue >.
Switch to reading data in rows
By default, Geckoboard reads the data in columns. When your data series is arranged in rows, click Switch columns and rows.
Configure your line chart widget
The visualization picker allows you to switch between the available options.
Enter minimum and maximum values for your line chart's Y-axis. Your line chart preview will change to reflect this.
In the Goal is field enter a value or select another single numeric value from your spreadsheet. Use the toggle to switch the shaded area from More than and Less than the goal value.
The Formatting menu allows you to overrule the automatically set number of decimal places used, or add additional information about the values on your widget. For more information, see our guide to using the data formatting options.