Create line charts using spreadsheets

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

Line_chart_widget.png

To create a line chart using spreadsheets, follow these steps:

  1. Click in the X-Axis field.X-axis_field.jpg
  2. Select the data from your spreadsheet for your X-Axis by either typing in a cell selection (e.g. A1:A13), clicking and dragging over your desired cells, or clicking to select an entire column or row in the Spreadsheet Data area. As you do this, the cells will highlight and you’ll see a live preview of your Line Chart.
  3. Click in the Series A field.Series_A_Field.jpg
  4. Select the data from your spreadsheet for your first Series by either typing in a cell selection (e.g. B1:B13), or clicking and dragging over your desired cells in the Spreadsheet Data area.

    Note: The Series fields will take numeric data, along with currency symbols and % signs.

    Tip: Use the Use first selection cells as header toggle to replace the series name with the value of the first selected cell.

  5. You can add multiple new series by clicking the + Add series button.Add_series_button.jpg
  6. Use the Goal toggle to activate the Goal field.Goal_field.jpg
  7. To add a Goal, type in the goal number, or select a particular cell from the Spreadsheet Data area. Grey shading will be added to your Line Chart above the goal line to reflect this.
  8. Use the Chart Options toggle to turn on additional options. Here you can specify minimum and maximum values for your Y-axis.Chart_options.jpg
  9. To specify the Y-axis minimum and maximum, you can type these in, or select the cells from the Spreadsheet Data area. The Y-axis on your Line Chart will change to reflect this.
  10. Give your widget a Title.
  11. When you’re happy with your Line Chart, click Add to dashboard.Add_to_dashboard.jpg
  12. And you're done!

Line_Chart_result.gif

More ways to visualize your spreadsheets

Now that you’re familiar with how to create a line chart, read our dedicated guides to creating the different visualizations available.

  • Column Chart
    Plots a series of data as vertical columns, with the option for individual labels for each column and a goal field, which can be set to highlight values above a specific target.
  • Bar Chart
    Plots a series of data in a horizontal bar chart, with the option for individual labels for each column and a goal field, which can be set to highlight values above a specific target.
  • Number Widget
    Consists of a single number pulled from a specified cell. Enables you to visually compare two figures with 4 comparison visualizations:
    • Sparkline
      Displays a primary metric with a sparkline (a small line chart) below it.
    • Percentage
      Displays a primary metric with a percentage change value below it that compares the primary metric with a secondary number.
    • Number
      Displays a primary metric with a value change below it that is a calculation of the difference between the primary metric and a secondary number.
    • Goal
      Displays a primary metric with a goal change below it that is a calculation of the difference between the primary metric and a secondary number.
  • Leaderboard
    Consists of a ranked list of items, each with a label and an optional value.
  • Geck-O-Meter
    A gauge visualization to quickly see a metric in comparison to defined minimum and maximum values.
  • Text
    Displays non-numerical data from a cell, or multiple cells, in a spreadsheet.
Was this article helpful?
👍

Thank you for your feedback!