This article describes how to create several column charts using small multiples (panel charts), starting with an existing table like this:
We will end up with several small column charts like this:
Requirements
- A table with at least two columns and at least one row.
Method - Via the visualization menu
- From the toolbar, select Visualization > Column > Small Multiples Column.
- Click on the page to place the visualization.
- Under Data > Data Source > Data select the table that you want to base the chart on. Alternatively, in Data > Data Source > Variables, select the data that you would like to be in the rows.
- OPTIONAL: If using Variables in Step 3, select the secondary variable to use as your cluster in Data > Data Source > Groups.
- OPTIONAL: Under Chart > Appearance change the value in Number of rows of panels to 1 (this will ensure the three charts end up next to each other. Setting this to 2 or higher would show the charts one above the other).
- OPTIONAL: Under Chart make additional adjustments to change the appearance of the visualization.
- Click Calculate and/or ensure that Calculate automatically is checked.
Method 2 - Using an existing table
- Select the table.
- From the object inspector, go to Visualization > Column > Small Multiples Column.
- OPTIONAL: Under Chart > Appearance change the value in Number of rows of panels to 1 (this will ensure the three charts end up next to each other. Setting this to 2 or higher would show the charts one above the other).
- OPTIONAL: Under Chart make additional adjustments to change the appearance of the visualization.
- 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 a 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 Bar 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