IMPORTANT: This document is specific to Sigma Workbooks. If you instead want to learn about this topic in worksheets, please visit Line Charts (Worksheets).

Summary of Content

Plot a Line Chart
      Required Fields
      Marks
Format Options
      Add Data Labels
Related Resources

Plot a Line Chart

Line charts can be created via the PAGE ELEMENTS section of your workbook's editor panel or directly from an existing data element

Required Fields

  • X-AXIS (1 column)
  • Y-AXIS (1+ columns)
    Columns added to the Y-AXIS field are aggregated by default. Aggregation type (e.g. Sum vs Count) is dependent on the original column’s value type (e.g. text, number, date, etc).
    For example, a numeric column such as 'Sales Amount' will create a new calculated column, 'Sum of Sales Amount' (e.g. Sum([Sales Amount])).

Screen_Shot_2021-06-01_at_3.37.11_PM.png

Marks

  • COLOR: choose a color for the line or a field to use to split the line into different colored lines (like the Product Family example in the screenshot below).
  • TOOLTIP: choose columns to show when hovering over points in the chart.
  • TRELLIS: select columns to serve as Trellis Rows or Columns, splitting the chart into separate charts.
    Screen_Shot_2021-06-01_at_3.39.09_PM.png

Format Options

To begin editing a visualization's format options, select the visualization to open its editor panel view. Then click the paint brush icon at the top of the editor panel.

Screen_Shot_2021-05-12_at_4.04.48_PM_copy.png

The following Format options are available for bar charts:

  • Title
  • X-Axis
  • Y-Axis
  • Legend
  • Data Labels
  • Reference Lines
  • Shape

Add Data Labels

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

  1. Open the chart’s editor panel view, and click the paintbrush icon to open the format settings. 
  2. Click DATA LABELS.
  3. Click Show data labels.
  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.

Related Resources

Intro to Building Visualizations