How to Create a Line Chart Visualization from a Table

This article describes how to create a line chart visualization from a data table. It will take you from a table like this:

To a Page that like this:

Requirements

A crosstab table with at least two rows or columns.

Method 1 - Via the visualization menu

From the toolbar, click Visualization > Line > Line. A new object will be created on the Page.
Under Data > Data Source click the dropdown to see all your tables and other outputs in this project. Select the desired crosstab table.
You'll notice that the chart shows the data split by columns as a series. To fix it, go to Data > Data Manipulation and tick the Switch rows and columns box.
OPTIONAL: To change the color selection, go to Chart > Data Series > Color palette and change it to the desired palette.

Method 2 - Using an existing table

Select the table.
From the object inspector, click Visualization > Line > Line.
OPTIONAL: Under the Chart tab, you can make further adjustments to the appearance of the visualization.

Note

Important information about editing captions:

Visualization caption edits may not be retained when a visualization with a nested table is switched back to a table. Normally, this only occurs when you double-click the caption and edit the text directly. As a workaround, we recommend using Appearance > Caption > Edit caption to edit your captions.

How to Create a Line Chart

How to Smooth the Curves on a Line Chart Visualization

How to Show a Moving (Rolled) Average on a Line Chart Visualization

How to Add a Line to a Column Chart (Second Y-axis)