This article describes how to go from a chart which shows the overall preference of Coca-Cola:
To a column chart showing trend over time by interview date:
The results from a particular time period are shown as columns. Significance tests, shown as arrows, compare the categorical period with the previous categorical period (see Tests Of Statistical Significance).
The lines below each column show how the result has changed over time. Lines that trend significantly upwards or downwards are color-coded, using the same method as for trend plots (see Significance Tests on Trend Plots).
Requirements
A column chart with trend can be used to show the relationship between a Date question and either:
- Nominal, Ordinal, Binary-Multi, or Numeric-Multi question
- Date variable
Method
- Select Visualization > Time Series > Column with Trend Tests
- Click on the page where you want your chart
- Select either a categorical or numeric variable for the Rows and a Date variable for the Date Question. In this example, we selected Coca-Cola and Interview Date.
The results are as follows:
Next
How to Create a Time Series - Small Multiples with Tests for Trends Chart