Versions Compared

Key

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

...

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

 Column 1Column 2 (and beyond...)

Column 3

Column 4

Data Type

Text or number

NumberNumberNumber

 

Contents

 

The name of the data being compared in your chart

  • The value of column 1 as displayed on the x-axis
  • This column represents a bar in your chart
  • 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 formatting:

Name
 Name of Country

United States

Soviet Union


 Gold Medals
321
211

                                                                     

Silver Medals
158
147
Bronze Medals
333
25

...



Customization Options

Go to Customize Your Chart

...