Configure a Line or Multi-Line Chart

A line chart will start to build with a column and a value. Values should be numeric, as they'll be plotted on a chart. Columns are often dates or categories in a series. To create a line chart or a multi-line chart, follow these basic steps:

1) Name the Line Chart

First, give the line chart a unique name. Something that gives a summary of the data you're setting out to visualize.

superchart line chart change name
Line Chart - Name

After naming the line chart, start by configuring a column.

2) Add a Column

The first key configuration to a line chart is the column, or the x-axis configuration of the line chart. If you're using dates, they likely belong in the column configuration of the line chart.

superchart line chart add column
Line Chart - Column

After adding a column, you'll want to add at least one value and configure the aggregation method.

3) Add a Value

Adding a value after having a column configured will begin to build out the chart. Check the aggregate function (i.e. sum, average, min/max, etc.) used on the value.

superchart line chart add value
Line Chart - Value

You can add multiple values if you want to show a multi-line or grouped line chart.

4) Add a Filter (Optional)

If you want to minimize the data to a smaller set, utilize filters to pare the data down.

superchart line chart filter
Line Chart - Filter

In this case, date filters can help you hone in on the right time scale.

Example Google Sheets Embedded Line Chart

In the embed below, we have some Gas Emissions Data over time displayed in a line chart as a very basic example.

Last Updated
March 6, 2023