UPCOMING WEBINAR: DIY Data Cleaning & Prep: Super Fast, Super Good This article describes how to go from a crosstab that contains a date or time variable in the rows or columns...
...to a state where the data is represented by a line chart to see trends over time:
Requirements
You will need a date/time variable, along with a variable that you would like to see trended over time.
Method 1 - Via the visualization menu
- From the toolbar, click Visualization
> Line > Line.
- Click onto the page to place the visualization.
- Under Data > Data Source click the dropdown, select an existing table from the Data dropdown, or select your Date/Time variable from the Variables dropdown.
- OPTIONAL: If you selected a Variable in Step 3, select the variable you'd like to cross the date data within the Groups dropdown.
- OPTIONAL: If you notice that the chart shows the data split by columns as a series go to Data > Data Manipulation and tick the Switch rows and columns box.
- OPTIONAL: Under the Chart tab, you can make further adjustments to the appearance of the visualization.
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.
Next
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)
How to Create Small Multiples (Facet, or Panel) Visualizations