Sometimes it's helpful to delineate groups of categories (such as bad vs good) on a visualization to help compare across items. You can do this by making a bar graph with the axis in the middle of the visualization and negative values/attributes on the left of the axis.
For example, the table below contains positive, neutral, and negative attributes:
Which can then be displayed as a bar chart visualization with the axis in the middle and positive and negative attributes shown on either side of the axis:
Requirements
- A Nominal Multi-Grid or Ordinal Multi-Grid variable set with at least one positive and one negative attribute, such as "like" and "dislike".
Method
- Recode your rating categories so the negative ratings have negative values, and the positive ratings have positive values. Select the variable set in the Data Sets tree, and in the Object Inspector click the DATA VALUES > Values button.
- Update the Value column as in the following example, assigning negative values to the negative attributes and positive values to the positive attributes. This determines whether the category will go on the right (positive value) or left (negative value) of the middle axis - the actual magnitude doesn't do anything to the chart. Click OK:
- Drag the variable onto the Page to create a summary table.
-
OPTIONAL: Combine categories on the table if you'd like to show them combined in the chart.
- Drag and drop the stack categories on the table to order them in the order you want to show them in the chart worst to best (left to right or top to bottom depending on if the stack categories are in the columns or rows).
-
With the table selected, in the object inspector go to Visualization > Bar > Stacked Bar with Tests.
OPTIONAL: You can further customize the look of the chart via the Chart tab in the object inspector.
Next
How to Create a Bar Chart from a Table
How to Create a Stacked Bar Chart
Comments
0 comments
Article is closed for comments.