0
0
Google Sheetsspreadsheet~15 mins

Line charts in Google Sheets - Real Business Scenario

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Scenario Mode
👤 Your Role: You are a sales analyst at a retail company.
📋 Request: Your manager wants to see how monthly sales have changed over the first half of the year to identify trends.
📊 Data: You have monthly sales data for six months, including the month name and total sales amount.
🎯 Deliverable: Create a line chart in Google Sheets that shows the sales trend from January to June.
Progress0 / 5 steps
Sample Data
MonthSales
January1200
February1500
March1700
April1600
May1800
June2000
1
Step 1: Enter the monthly sales data into Google Sheets with 'Month' in column A and 'Sales' in column B, starting from row 1.
No formula needed for this step.
Expected Result
Headers 'Month' and 'Sales' in A1:B1, months in A2:A7 and sales in B2:B7.
2
Step 2: Select the data range A1:B7 including headers.
No formula needed for this step.
Expected Result
Cells A1 to B7 are selected.
3
Step 3: Insert a line chart: Go to Insert > Chart. In the Chart editor, set Chart type to 'Line chart'.
No formula needed; use Google Sheets UI.
Expected Result
A line chart appears showing months on the horizontal axis and sales on the vertical axis.
4
Step 4: Customize the chart title to 'Monthly Sales Trend (Jan-Jun)'.
In Chart editor under 'Customize' > 'Chart & axis titles', set Title text to 'Monthly Sales Trend (Jan-Jun)'.
Expected Result
Chart title updates to 'Monthly Sales Trend (Jan-Jun)'.
5
Step 5: Ensure the horizontal axis shows months in order and vertical axis shows sales values clearly.
No formula needed; verify axis labels in Chart editor.
Expected Result
Chart axes are labeled correctly with months and sales values.
Final Result
Monthly Sales Trend (Jan-Jun)

  2000 |                      *
  1800 |                 *    
  1600 |            *          
  1400 |       *               
  1200 |  *                   
        --------------------------------
         Jan Feb Mar Apr May Jun
✓Sales increased steadily from January to March.
✓There was a slight dip in April sales.
✓Sales rose again in May and reached the highest point in June.
Bonus Challenge

Add a second line to the chart showing the monthly sales target and compare actual sales against targets.

Show Hint
Add a new column 'Target' next to 'Sales' with target values, then select all three columns when creating the chart.