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.