Bar charts

Bar 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 bar 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 data in your spreadsheet. 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.

bar chart

Stacked bar chart

Data for a stacked bar chart is structured similarly to a bar chart, but data for each label or classification is aggregated into one bar, instead of multiple bars. This bar contains all data for any given label or classification, and allows you to see the relationship of parts to the whole.

stacked bar chart

Learn how to customize your chart.

Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.

How helpful is this article:

Feedback recorded. Thanks!
  • Not at all helpful
  • Not very helpful
  • Somewhat helpful
  • Very helpful
  • Extremely helpful