Why charts make data visual in Google Sheets - Business Case Study

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a clear visual report showing monthly sales trends for different product categories.

📊 Data: You have monthly sales data for three product categories: Electronics, Clothing, and Home Goods. The data shows sales amounts for each month from January to June.

🎯 Deliverable: Create a line chart in Google Sheets that visually displays the sales trends for each product category over the six months.

Sample Data

Month	Electronics	Clothing	Home Goods
January	1200	800	600
February	1500	700	650
March	1700	900	700
April	1600	850	720
May	1800	950	750
June	2000	1000	800

1

Step 1: Enter the sales data into Google Sheets exactly as shown in the sample data table, with months in column A and sales numbers for each category in columns B, C, and D.

No formula needed for this step.

Expected Result

Data is organized in a clear table with headers: Month, Electronics, Clothing, Home Goods.

2

Step 2: Select the entire data range including headers (A1:D7).

No formula needed for this step.

Expected Result

The data range is highlighted and ready for chart creation.

3

Step 3: Insert a line chart by clicking Insert > Chart from the menu.

Use the Chart Editor to select 'Line chart' as the Chart type.

Expected Result

A line chart appears showing sales trends for Electronics, Clothing, and Home Goods over the months.

4

Step 4: Customize the chart title to 'Monthly Sales Trends by Product Category'.

In Chart Editor, under 'Customize' > 'Chart & axis titles', enter the new title.

Expected Result

The chart title clearly describes the data shown.

5

Step 5: Add axis titles: 'Month' for the horizontal axis and 'Sales Amount ($)' for the vertical axis.

In Chart Editor, under 'Customize' > 'Chart & axis titles', select 'Horizontal axis title' and 'Vertical axis title' to enter the labels.

Expected Result

The chart axes are labeled to help understand the data.

Final Result

Monthly Sales Trends by Product Category

Month      Electronics   Clothing   Home Goods
------------------------------------------------
Jan        *            *          *
Feb        **           *          *
Mar        ***          **         **
Apr        ***          **         **
May        ****         ***        **
Jun        *****        ***        ***

* Each '*' represents relative sales amount on the line chart

✓Electronics sales steadily increased from January to June.

✓Clothing sales fluctuated but showed a general upward trend.

✓Home Goods sales grew slowly but consistently over the months.

✓The line chart makes it easy to compare trends across categories visually.

Bonus Challenge

Create a bar chart next to the line chart to compare total sales per product category for the six months.

Show Hint

Use the SUM function to calculate total sales for each category, then select those totals to insert a bar chart.

Practice

1. Why do charts help us understand data better in Google Sheets?

easy

A. Because charts show data as pictures, making patterns easier to see

B. Because charts hide the data so you don't get confused

C. Because charts delete numbers from the sheet

D. Because charts make the sheet load faster

Solution

1. Step 1: Understand what charts do

   Charts turn numbers into pictures like bars or lines.

2. Step 2: Recognize why pictures help

   Pictures make it easier to spot trends and compare data quickly.

3. Final Answer:

   Because charts show data as pictures, making patterns easier to see -> Option A

4. Quick Check:

   Charts = Visual data easier to understand [OK]

Hint: Charts turn numbers into pictures for quick understanding [OK]

Common Mistakes:

• Thinking charts hide data
• Believing charts delete numbers
• Assuming charts speed up sheet loading

2. Which menu option do you use in Google Sheets to create a chart?

easy

A. Insert > Chart

B. Format > Text

C. File > Save

D. Data > Sort

Solution

1. Step 1: Recall the menu for adding charts

   Charts are added using the Insert menu in Google Sheets.

2. Step 2: Identify the correct submenu

   The correct submenu is Chart under Insert.

3. Final Answer:

   Insert > Chart -> Option A

4. Quick Check:

   Insert > Chart = Add chart [OK]

Hint: Use Insert menu to add charts quickly [OK]

Common Mistakes:

• Choosing File or Format menus instead
• Selecting Data > Sort which is for sorting
• Confusing chart creation with saving

3. You have monthly sales data in column A (months) and column B (sales). You select both columns and insert a chart. What type of chart will best show sales trends over time?

medium

A. Pie chart

B. Line chart

C. Scatter plot

D. Histogram

Solution

1. Step 1: Understand the data type

   Months and sales data show values changing over time.

2. Step 2: Choose chart type for trends

   Line charts connect points over time to show trends clearly.

3. Final Answer:

   Line chart -> Option B

4. Quick Check:

   Time series data = Line chart [OK]

Hint: Use line charts to show trends over time [OK]

Common Mistakes:

• Using pie charts which show parts of a whole
• Choosing scatter plots which show relationships, not trends
• Selecting histograms which show frequency, not trends

4. You inserted a chart but it shows wrong data. What is the most likely cause?

medium

A. You typed the chart title incorrectly

B. You forgot to save the sheet

C. You used the Format menu instead of Insert

D. You selected the wrong cells before inserting the chart

Solution

1. Step 1: Identify common chart errors

   Wrong data usually means the selected cells were incorrect.

2. Step 2: Check other options

   Saving or menu choice does not affect data shown; title text does not change data.

3. Final Answer:

   You selected the wrong cells before inserting the chart -> Option D

4. Quick Check:

   Wrong chart data = Wrong cell selection [OK]

Hint: Always select correct cells before inserting chart [OK]

Common Mistakes:

• Blaming save or menu choice
• Thinking title text affects data
• Not checking cell selection carefully

5. You have sales data for 4 products over 12 months. You want to compare each product's sales visually and see which product sells best each month. Which chart type should you choose and why?

hard

A. Line chart, because it shows trends for each product over months

B. Pie chart, because it shows each product's share of total sales

C. Stacked column chart, because it shows total and parts per month

D. Scatter plot, because it shows correlation between products

Solution

1. Step 1: Understand the data and goal

   Data has multiple products over months; goal is to compare sales per month and total.

2. Step 2: Evaluate chart types

   Stacked column charts show each product's contribution per month and total height shows total sales.

3. Step 3: Why others don't fit

   Pie charts show parts of one total only, line charts show trends but not clear monthly totals, scatter plots show relationships, not comparisons.

4. Final Answer:

   Stacked column chart, because it shows total and parts per month -> Option C

5. Quick Check:

   Compare parts and total monthly = Stacked column chart [OK]

Hint: Use stacked columns to compare parts and totals monthly [OK]

Common Mistakes:

• Choosing pie charts for multiple months
• Using line charts without clear monthly totals
• Picking scatter plots which don't compare sales