Line charts visually display change over time.

 ⭐️Here's a short tutorial on how to use charts in Workbench.
 

Preparing data

In Workbench, all charts expect data to be organized in columns. 

If your values are organized in  rows, start by turning them into columns, using the Transpose step.  

If transposing isn’t enough to organize your data into columns, you may need to reshape your data from long to wide format. Our reshaping tutorial will help you learn how to spot the different formats, and switch between them. 

Make sure the values you actually want to display on the chart are numeric -- use the convert to number module if you need to convert them. 

Plotting data

Once your data is arranged in columns, you can add the line chart module to plot a chart. 

Set the X axis 

  • Select the column containing the values that should be displayed along the horizontal axis
  • If appropriate, enter a label to be displayed below the horizontal axis.

Set the Y axis

  • Select at least one column to display its values on the vertical axis. Use the +  button at the bottom of the step to plot additional columns and compare them.   
  • If appropriate, add a label to be displayed on the left of the chart.

Caveats

Our Line Chart tool will let you select categorical data for your x-axis -- that’s handy in cases where a column might contain linear values that aren’t stored numerically (eg. months or weekdays) but you should be sure that you aren’t creating a linear relationship where none exists.

Exporting

You can export a PNG or SVG file using the export button at the top right of the chart.

Custom styling with VEGA

Workbench charts are built using VEGA, an awesome visualization grammar. 

Access the Vega editor from the download menu. Click the option Open Vega Editor to open the VEGA interface. More info about VEGA here.

Did this answer your question?