Tuesday, September 8, 2020

How to Make Simple Bar Chart in Google Sheets

 


Bar charts are allow readers to understand item counts at a glance. In micro school math instruction, you may want to use bar charts as a learning objects, which can be created as part of the constructivist learning process.

Using Google Sheets to create a bar chart is simple.

We will use a bag of candy (Milk Chocolate M&M's) as an example data set. The bag of candy contains chocolate lentils. Each lentil is one of six colors.
  • Red
  • Green
  • Blue
  • Brown
  • Yellow
  • Orange
For our bar chart, we will use a single-letter symbol to represent each of the six candy colors. Assigning symbols to each color can be very helpful for analysis of sets or combinations.

RedR
BlueG
GreenB
BrownW
YellowY
OrangeN

Collectively, we refer to this set of colors as RGBWYN (pronounced as "rugby win" as heard on Google Translate).  

We count the number of lentils in the bag of candy, and we find the following quantities:

R14
G8
B12
W5
Y8
N11

We can switch the columns and remove the headers in Google Sheets like so:


This is the data set we can now use to generate a bar chart.

From the Insert menu, select the Chart item, and Google Sheets will automatically (or automagically) create a bar chart with your data set.

Here is a video example of how to make a bar chart in Google Sheets.




This is only a simple bar chart that represents the frequency of colors in a bag of chocolate candy. However, bar charts can describe the frequency of anything, which makes these charts a wonderful tool for exploring statistics.

CCSS.MATH.CONTENT.7.G.B.4: Circumference and Paper Towel Rolls

This article describes a math activity for learning about circumference. CCSS.MATH.CONTENT.7.G.B.4:  Know the formulas for the area and circ...