Column charts

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.

Data Format

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 column 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.

column chart

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.

stacked column chart

Histogram

A histogram displays the distribution of a data set. In your spreadsheet's first column, put labels for your groups of data. Then, in subsequent columns, place numeric values, each representing items in a distribution. Only one column of data is required to generate the histogram.

For each column, the values from all rows are grouped into numeric buckets. The histogram displays the number of values in each bucket, using the height of each bar to represent the count of values.

Learn how to customize your chart.