This article describes how to go from a table containing multiple variables:
To a state where you display the table in a stacked area chart:
You will need one of the following:
- A Multiway table. To create a multiway table select Table > Multiway from the toolbar. From the object inspector, go to Inputs and select the Rows, Columns, and Numeric inputs.
- A crosstab, which is a table that shows the relationship between two or more variables.
- A table of data pasted from a spreadsheet.
Method 1 - From the visualization menu
- In the toolbar, go to Visualization > Area > Stacked Area.
- From the object Inspector, you have 3 different methods for providing input data to the area chart. In the DATA SOURCE section, use one of the following:
- Output in 'Pages' - select a table output.
- Variables in 'Data' - select an individual variable from the Data Sets tree. Once an item is selected a second drop-down called Groups will appear in the object inspector. Here you can select a second variable to create a crosstab.
- Paste or Type data button - copy and paste data from Excel or some other source directly into a spreadsheet object in Displayr.
Method 2 - From an existing table
- Select the multiway table or crosstab on the page.
- From the object inspector, go to Visualization > Area > Stacked Area.
Important information about editing captions:
Visualization caption edits may not be retained when a visualization with a nested table is switched back to table. Normally, this only occurs when you double-click the caption and edit the text directly. As a workaround, we recommend using Properties > CAPTION > Edit caption to edit your captions.
Note that when there are missing values inside the series (i.e. not at the ends of the series) are present, lines are shown along the edge of an Area Chart, with missing segments between points indicating missing values. Stacked Area Charts cannot be plotted with missing values.