Line Charts

Summary of Content

Create a Line Chart
Plot Options
Format Options
      Add Data Labels
Related Resources

Create a Line Chart

  1. Open the visualization tab in your worksheet’s right hand panel.

  2. Click on the blue + icon to add a new visualization.
    This will open up the visualization’s plot and format panel.

  3. Click on the line chart icon button under ‘VISUALIZATION TYPE’.
    Screen_Shot_2020-09-03_at_3.26.10_PM.png

  4. On the Plot tab, add one column under Axis and one or more columns under Value.line-axis-value.gif

  5. [optional] If you would like to create a multi-series line chart, add a column to the Color field.
  6. [optional] Add one or more columns to the Details field.
  7. [optional] Use Trellis Row and/or Trellis Column to create a trellis chart.

Plot Options

Basic line charts require one column plotted on the chart Axis and one or more columns plotted as Values. 

The following Plot field options are available:

  • Axis (1+ columns)
  • Value (1+)
  • Color (1)
  • Detail (1+)
  • Trellis Row (1)
  • Trellis Column (1)

Format Options

The following Format options are available for line charts: Theme, General, Title, X-Axis, Y-Axis, Legend, Reference Lines, and Shape. Learn more.

Add Data Labels

When data labels are added to a line chart, they are applied to every line in the visualization. 

  1. Open the Format tab in the visualization’s Plot and Format panel.

  2. Click on the DATA LABELS header.

  3. Switch on Show Data Labels.
    Screen_Shot_2020-09-10_at_5.26.08_PM.png

  4. [optional] Select a Label Style from the following list:

    Min - Displays the line’s minimum value.
    Max - Displays the line’s maximum value.
    Min/Max - Displays both the minimum and maximum values.
    Endpoints - Displays the values at both the beginning and the end of the line.
    All - Displays all values on the line, when possible. Value labels may be excluded to prevent overlap. 

    Please note: If the selected label style is Min, Max, or Min/Max and applies to multiple identical values on a line, both instances will be displayed. For example, if “Min” is selected, and the line has two instances of its minimum value, both will be labeled.

  5. [optional] Select a custom Color.

  6. [optional] Select a custom Font size.
    Screen_Shot_2020-09-10_at_5.34.16_PM.png

Related Resources

Visualize your Data
Format Your Chart
Trellis Charts