Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Example

 

A bar chart is a chart used to compare grouped data. The bars span horizontally across the y-axis and display their values along the x-axis, as seen in the example above.

 

 

Spreadsheet Format

Each row represents one category on the x-axis. Learn more about using spreadsheets with Visuals at Use Spreadsheet Data.

 Column 1Column 2Column 3 (and beyond...)
Data Type
Text
plain text or numbersnumber
Number

 

number
Number
Contents

The

label along the x-axis representing each bar or group

category of the data point on the y-axis.

Note:

  • These will next to each set of bars

The value of

column 1 as displayed

the data point on the x-axis

. This

column represents a bar in your chart

forms the column.

An additional x-axis value for the category in

The value of column 1 as displayed on

the x-axis

.This

forms

creates a

second set of bars on your chart

data set with an extra column.

Note:

  • You can have as many additional columns as you want to create new data sets. For example, if you were creating a column chart of Olympic medals per country, and had "USA" and "France" in Column 1, you could create three additional columns for "Bronze", "Silver", and "Gold" medal breakdowns.
Data Label

The title of the x-axis

Note:

  • This will appear next to the individual categories

Label

 Category of the bar
  • on the y-axis

Notes:

 

Category of the bar in the legend

 

 

The bar's group

Note:

  • This determines the color of the bar; bars in the same group will share a color
  • This labels the group (and group color) in the legend

 The bar's group

 

Note:

  • This determines the color of the bar; bars in the same group will share a color
  • This labels the group (and group color) in the legend
Requiredxx 

 

 

 

Your spreadsheet might The first two columns in your spreadsheet may look like this:                                        

 Name of Country CountryGold MedalsSilver MedalsBronze Medals

United States

3212278
Soviet Union211

...

4135

Customization Options

Learn about options at Common Customization Options