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 Inputs > OUTPUT > Visualization > Area > Stacked Area 100%.
OPTIONAL: You can make further adjustments to the appearance via the Chart options in the object inspector.