Versions Compared

Old Version 9

changes.mady.by.user Unknown User (rpr6ha)

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

 

Bar charts are a way A bar chart is a chart used to compare grouped data sets. Each bar represents a subject and its value. The bars display span horizontally across the y-axis and have display their values along the x-axis, as seen in the example above.

 

The spreadsheet is formatted with a minimum of two sets of values: name of the data being compared + number. Each column in the spreadsheet represents a bar in the chart.

Spreadsheet Format

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

 Column 1Column 2Column 3 (and beyond...)

Column 3

Column 4
Data Type
Text
plain text or numbers
Number
number
Number
number
Number
Contents

The

names

category of the data

sets being displayed in your chart

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 forms the column.

An additional x-axis value for the category in the x-axis.This

column represents a bar in your chart

creates a 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 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
    ExampleCountries: United States, Soviet Union United Kingdom, France, China, JapanNumber of gold medals each country won at the OlympicsNumber of silver medals each country won at the OlympicsNumber of bronze medals each country won at the Olympics

     

    Customization Options

    Go to Customize Your Chart

    Note:

    • This will appear next to the individual categories on the 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 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.