This article describes how to go from a table containing multiple variables:
To a state where you display the table in a stacked area visualization that totals 100%:
A 100% Stacked Area chart rescales the values of each series so that they all add up to 100%, presenting the values as a proportion of the whole.
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 - Create via the visualization menu
- In the toolbar, go to Visualization > Area > Stacked Area 100%.
- Drag the cursor over the page to place the visualization.
- 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 - Create using an existing table
- Select an existing table (either crosstab or multiway).
- From the object inspector, go to Visualization > Area > Stacked Area 100%.
OPTIONAL: You can make further adjustments to the appearance via the Chart options in the object inspector.
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.