Versions Compared

Key

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

...

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

 Column 1Column 2

Column 3 (and beyond...)

Data Type

text or number

numbernumber

 

Contents

The label for each category on the x-axis

Note:

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

 

The y-value for the category 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-value for the category on the x-axis

Note:

  • This creates a second bar for the category in Column 1
  • This creates a second group of bars in the legend
  • You can have as many groups as you need: each new column makes a group

Data Label

The title of the x-axis

Note:

  • This will appear below the individual labels on the x-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:                                        

...