The Confluence production environment will undergo a migration from 8am-5pm ET on Saturday, May 25th. The Confluence environment will be available in read only mode. Changes to data in Confluence will not be possible until the migration is complete.
Example
A bar chart is a chart used to compare grouped data. Each bar represents a subject and its value. The bars span horizontally across the y-axis and display their values along the x-axis, as seen in the example above.
The spreadsheet is made using two sets of values: name of the data being compared + number. The names (see column 1 in the table below) show up as categories along the chart's y-axis. The numbers (see Column 2, 3, and 4 in the table below) form a bar in the chart. Use the table below as a reference on how to format your spreadsheet to create a bar chart.
Spreadsheet Format
Spreadsheet Format
Each row represents one category on the x-axis. Learn more about using spreadsheets with Visuals at Use Spreadsheet Data.
Column 1 | Column 2 | Column 3 (and beyond...) |
---|
Column 3
Data Type |
---|
plain text or numbers | number |
Contents
number |
Contents |
---|
The |
category of the data |
point on the y-axis. Note:
| The value of |
the data point on the x-axis. This forms the column. | An additional x-axis value for the category in the x-axis.This |
creates a data set with an extra column. Note:
| |
Data Label | The title of |
---|
the x-axis |
Note:
| The bar's group Note:
| The bar's group
Note:
| |
Required | x | x |
---|
Example
...
Name of Country |
---|
United States |
Soviet Union |
...
Gold Medals |
---|
321 |
211 |
...
Silver Medals |
---|
158 |
147 |
...
Bronze Medals |
---|
333 |
25 |
Your spreadsheet might look like this:
Country | Gold Medals | Silver Medals | Bronze Medals |
---|---|---|---|
United States | 321 | 22 | 78 |
Soviet Union | 211 | 41 | 35 |
Customization Options
Learn about options at Common Customization Options.
Customization Options
Go to Customize Your Chart