...
| | Column 1 | Column 2 | Column 3 (and beyond...) |
|---|
| Data Type | plain text or numbers | number | number |
|---|
| Contents | The category of the data point on the y-axis. Note: - These will appear beneath next to each set of bars on the x-axis
| The value of the data point on the x-axis. This forms the column. | An additional x-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.
|
|---|
| Data Label | The title of the x-axis 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
|
|---|
| Required | x | x | |
|---|
Your spreadsheet might look like this:
...
