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.