Bar/Line Charts can be displayed as bar-only, line-only, or a bar and line combination visualization.
The bar charts are arranged as clustered bar visualizations.
Bar/Line Charts support both single-response questions such as Education, Age Groups, Occupation, etc. that sum to 100% as well as multi-choice questions such as Reasons for Purchase, Problems Experienced, Item Characteristics, and other questions where the percentages sum to over 100% because a respondent can choose more than one answer.
All numeric questions can be displayed in one visualization by adding each question to the Series panel.
The following example includes options and settings for a visualization built using the Bar/Line Chart.
Begin by changing the tab template to Bar/Line Chart.
Multiple questions can be included in the Categories and Series panels.
Optional questions can be included in the Filters panel.
Categories
Market Category of New Car, Segment of New Car, and Make of New Car are included in the Categories panel.
Series
Multiple numeric questions are included in the Series panel.
In the example above, each numeric question is included as a separate bar for each market category of new car.
Important: When working with a Bar-Line Combination chart, at least two numeric questions are required in the Series panel.
Pages
Adding the Dataset Year to the Pages panel allows for specifying and displaying only a single year of data (if multiple years of data are loaded).
Click the General Settings icon to display the available options.
Category Settings
Expand the Advanced Settings options and click the Categories drop-down menu.
In the example above, Market Category, Segment, and Make were included in the Categories panel during setup, which makes them available as options in the Categories menu.
Selecting the Segment menu option changes the analysis from Market Category of New Car to Segment of New Car.
Note the Segment of New Car descriptions:
Segment A, Segment B at the bottom of each group of bars and the < 1 / 4 > notation in the upper-right.
Clicking < 1 / 4 > will advance through each of the segments, so < 2 / 4 > will display the next set of slides (Segments C and D).
Series Settings
Click the Series drop-down menu.
In the example above, multiple numeric questions consisting of vehicle attribute ratings were included in the Series panel.
In addition to the numeric questions, Marital Status, a category question was also added.
Since Marital Status is a category question and is a different type of question than the numeric ratings, it is not automatically included and displayed with the other numeric questions.
Under the Series menu, either the numeric ratings questions can be selected (Basic Statistics) or the Marital Status question can be selected.
Selecting a category type question, such as Marital Status, in the Series menu will change the way the question is displayed as a bar chart.
Unlike numeric questions, where every question is displayed as a separate bar and is typically formatted as a mean, category questions are displayed by populating each response of the question as a bar.
In the Marital Status example above, the dark blue bars represent Married, the lighter blue bars represent Not Married, and the gray bar is the Total.
Pages
During the query setup, multiple years of data were included.
Since Dataset year is included in the Pages panel, it will act as a selectable filter to allow for displaying one year of data at a time in the bar chart.
Additional Features
Chart Type: Bar / Line / Combination Charts
To change the chart type from a Bar Chart (default), to a Line Chart, or a Bar-Line Chart click the Chart Type menu selection.
Reminder: The Bar-Line Combo option is only available when numeric questions are included in the Series panel.
Bar-Line Combo Charts
Complete the Bar-Line Combo chart by expanding the Statistics on Secondary Axis menu.
Reminder: When working with a Bar-Line Combo chart, at least two numeric questions are required in the Series panel.
Select one or more questions to display as lines instead of bars.
Additional questions can also be added.
In the example above, Number of Problems has been added to the Series panel and is selected as question to display as a line.
Select more than one secondary axis menu option to display multiple line charts.
Multiple questions can be displayed as lines by selecting more than one question in the Statistics on Secondary Axis menu.
In this example, "Number of Problems" and "Days Off Road Due to Faults" are plotted as line charts.
Note: If all available secondary axis statistics questions are selected, the bar/line combo chart will plot all data points and change to a line chart.
Bar-Line Combo Charts Trended
Move the Dataset Year question to the Categories panel and include a vehicle-related question (such as Segment) in the Pages panel to serve as a chart filter.
Categories should be set to Dataset Year and a selection to the Segment of New Car should be made.
(This example is including Segment C.)
Line Charts Trended
To display a trended line chart instead of a bar chart, setup the same query as the previous Bar-Line trended example above, but select the Line Chart option under the Chart Type menu.
Vertical and Horizontal Bars
The default for displaying bars is the vertical orientation.
To change from vertical bars to horizontal bars, click the Orientation menu and select Top to Bottom.
-
-
Horizontal = Top to Bottom
