Bar charts


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


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.


How helpful is this article:

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