Versions Compared

Key

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

Spreadsheet Format

Each row represents a data point on the chart.  Learn more about spreadsheets in Visuals at Use Spreadsheet Data.

 Column 1Column 2Column 3 (and beyond...)
Data Typeplain text or numbersnumbernumber
Contents

The category of the data point on the x-axis.

The value of the data point on the y-axis. This forms the column.

An additional y-axis value for the category in the x-axis.This 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.
Optional  x

Customization Options

Data Label

The title of the x-axis

Note:

  • This will appear below the individual categories 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 

Customization Options

Learn about options at Common Customization OptionsGo to Common Options for Charts and Graphs