Bar chart of competitive counts

So far you've examined numeric data. What should you do to learn about categorical data? This sheet contains 150 online auctions with non-numeric data. One method to explore this type of variable is with a bar chart, also called a "column chart".

Here, the COUNTIF() function has been to used to count the number of "1"s and "0"s. In DataCamp's Pivot Tables in Google Sheets course, you can learn efficient ways like this to count data.

Your job in this exercise is to create two types of bar charts: stacked, and side-by-side. The difference is subtle but helps your audience in different ways.

  • Stacked: helps you focus on the proportion of the total that is a particular class. You will visually understand the amount of the total that represents competitive online auctions.
  • Side-by-side: lets the audience understand the values in relation to each other. You will visually interpret how similar each class values are.

This exercise is part of the course

Introduction to Statistics in Google Sheets

View Course

Exercise instructions

  • Insert a column chart referencing D2:E2 in cell G1.
  • Create another visual of the same data at G10, this time selecting "Stacked column chart".

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise