0
0
Google Sheetsspreadsheet~15 mins

Chart customization (title, legend, colors) 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 a clear sales performance chart for the last quarter. They ask you to customize the chart with a meaningful title, adjust the legend position, and change the colors to match the company branding.
šŸ“Š Data: You have monthly sales data for three products (Product A, Product B, Product C) for the months October, November, and December.
šŸŽÆ Deliverable: Create a column chart showing sales per product per month with a custom title, legend positioned at the bottom, and colors set to blue for Product A, green for Product B, and orange for Product C.
Progress0 / 5 steps
Sample Data
MonthProduct AProduct BProduct C
October1200900700
November15001100950
December170013001200
1
Step 1: Select the data range including headers and months (A1:D4).
Expected Result
Data range selected for chart creation.
2
Step 2: Insert a column chart using the selected data.
Insert > Chart > Chart type: Column chart
Expected Result
A column chart appears showing sales for each product by month.
3
Step 3: Customize the chart title to 'Quarter 4 Sales Performance'.
Chart editor > Customize > Chart & axis titles > Chart title: 'Quarter 4 Sales Performance'
Expected Result
Chart title changes to 'Quarter 4 Sales Performance'.
4
Step 4: Set the legend position to the bottom of the chart.
Chart editor > Customize > Legend > Position: Bottom
Expected Result
Legend moves to the bottom of the chart.
5
Step 5: Change the colors of the bars: Product A to blue, Product B to green, Product C to orange.
Chart editor > Customize > Series > Select Product A > Color: Blue; Select Product B > Color: Green; Select Product C > Color: Orange
Expected Result
Bars for Product A are blue, Product B are green, and Product C are orange.
Final Result
Quarter 4 Sales Performance

Month     | Product A | Product B | Product C
---------------------------------------------
October   | ā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆ  | ā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆ   | ā–ˆā–ˆā–ˆā–ˆā–ˆ
November  | ā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆ| ā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆ  | ā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆ
December  | ā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆ| ā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆ| ā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆā–ˆ

Legend (bottom):
ā–ˆ Product A (Blue)  ā–ˆ Product B (Green)  ā–ˆ Product C (Orange)
āœ“Sales increased steadily from October to December for all products.
āœ“Product A consistently had the highest sales each month.
āœ“Custom colors and legend placement make the chart easier to read and match company branding.
Bonus Challenge

Add data labels on top of each bar showing the exact sales numbers.

Show Hint
Use Chart editor > Customize > Series > Data labels: On