How to Create a Column Chart

This article describes how to show data from variables or two different types of tables: summary tables with a single column and crosstabs with multiple columns, like these:

To column charts like these:

Requirements

A Displayr document with at least one of the following:

• A table with one or more columns, OR
• At least one variable or variable set with the following structure:
  • Nominal - Mutually exclusive categories structure, OR
  • A Date/ Time variable, OR
  • A multiple-response variable set structured as a Binary - Multi: Non-mutually exclusive categories

Method: Crom the visualization menu with a single-column table or one variable

1. Click Visualization > Column > Column from the toolbar.
2. Click on the page to place the visualization.
3. Under Data > Data Source > Data select the table that you want to base the chart on. Alternatively, select a nominal or date/time variable in the Variables dropdown.
4. OPTIONAL: If Variables is selected, tick Convert to Percentages/Proportions under Data Manipulation.
5. Click Calculate and/or ensure that Calculate automatically is checked.

Method: From the visualization menu with a multi-column table or two variables

1. Click Visualization > Column > Column from the toolbar.
2. Click on the page to place the visualization.
3. Under Data > Data Source > Data select the table that you want to base the chart on. Alternatively, select a nominal or date/time variable in the Variables and a second variable in the Groups dropdown.
4. OPTIONAL: If Variables is selected, tick Convert to Percentages/Proportions under Data Manipulation.
5. In Column Manipulations > Columns to show enter the label or index of the column.  In the example above, "Diet Coke" was entered. Alternatively, the number 2 could have been entered(the index of the second column on the table).
6. Click Calculate and/or ensure that Calculate automatically is checked.

Method: From an existing single-column table

1. Select the table.
2. From the object inspector, click Visualization > Column > Column.
3. Click Calculate and/or ensure that Calculate automatically is checked.

Method: From an existing multi-column table

1. Select the table.

2. From the object inspector, click Visualization > Column > Column.

3. Under Data > Column Manipulations > Columns to show enter the label or index of the column.  In the example above, "Diet Coke" was entered. Alternatively, the number 2 could have been entered (the index of the second column on the table).

4. Click Calculate and/or ensure that Calculate automatically is checked.

Note

Important information about editing captions: 

Visualization caption edits may not be retained when a visualization with a nested table is switched back to the table. Normally, this only occurs when you double-click the caption and edit the text directly. As a workaround, we recommend using Appearance > Caption > Edit caption to edit your captions.

Next

How to Create a Clustered Column Chart

How to Create a Stacked Column Chart

How to Create Several Column Charts Using Small Multiples

How to Add a Line to a Column Chart (Second Y-axis)

How to Customize the Color of a Single Category in a Bar, Column, or Pyramid Visualization

How to Apply a Gradient Palette to a Bar, Column, or Pyramid Visualization

How to Create Sparkline Visualizations