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