Versions Compared

Old Version 30

changes.mady.by.user Veronica Kuhn

Saved on

compared with

New Version Current

changes.mady.by.user Veronica Kuhn

Saved on

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 Typeplain text or
number
numbersnumbernumber
 
Contents

The

label for each category

category of the data point on the

x

y-axis.

Note:

  • These will
appear beneath
  • next to each set of bars
on the x-axis 

The

y-

value

for

of the

category

data point on the x-axis

Note:

  • This creates the bar for the category in Column 1
  • Bars in the same column share a group
A second y-

. This forms the column.

An additional x-axis value for the category

on

in the x-axis

Note:

.This creates a

second bar for the category in Column 1

data set with an extra column.

Note:

This creates a second group of bars in the legend

  • You can have as many
groups
  • additional columns as you
need: each new column makes a group
  • 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
below
  • next to the individual
labels
  • categories on the
x
  • y-axis

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

 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 look like this:                                        

 CountryGold MedalsSilver MedalsBronze Medals

United States

3212278
Soviet Union2114135

Customization Options

Learn about options at Common Customization Options.