A column chart with trend can be used to show the relationship between a Date question and either a Pick One, Pick Any or Number - Multi question. An example is shown below.
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).
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:
- Pick One, Pick Any or Number - Multi question.
- Date question
Method
- Select View > Show Data as > Column chart with trend
- Select a Date Question from the pull-down menu at the bottom of chart
The results are as follows:
Q 4.11 and Later
The time period and date range to use is selected by going to the Trend Lines section in the Chart settings to the right of the chart and changing the Aggregation and Period Type selections.
Older Versions of Q
The time period to use is selected by right-clicking on the columns, selecting Format All Series, and changing the settings in the Categorical Period tab.
The date range for the trend plots shown beneath are selected by right-clicking on the trend lines and selecting Format/Configure trends.
Next
How to Create a Time Series Graph