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 |
| 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 |
- The value of column 1 as displayed on the x-axis
- This forms a second bar in your chart
- The value of column 1 as displayed on the x-axis
- This forms a third bar in your chart
Example
Name of Country
Number of gold medals
Number of silver medals
Number of bronze medals
Example format of the first two columns
...
United States
...
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 |
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