Column charts are a good way to visualize one or more categories of data, particularly if each category has sub-categories. These charts allow you to visually express the difference between the data points of each category. In the chart below, for example, we can track Olympic medals earned by country, with the sub-categories of Gold, Silver and Bronze medals.
Each row in your spreadsheet represents a different column in the chart. In the first column of your spreadsheet, write the labels or classifications for each row. For example, this could be countries or other classifications of data. Each remaining column needs to contain numeric data. The data format for a area chart is the same as the data format for bar, line, and area charts.
You may also want to name each of the columns containing your data. If you do so, we’ll automatically detect these names and use them as labels for your data on the chart. You can also set or change this setting by selecting the checkbox that reads ‘Use Row A as headers.’
Last, you can chart uncertainty about your data using boolean values.
Stacked column chart
Data for a stacked column chart is structured in the same way as a standard column chart. In stacked column charts, however, each category has only one column. This column contains all data for any given label or classification, and allows you to see the relationship of parts to the whole.
Learn how to customize your chart.