Chart elements (title, legend, axis labels) in Excel - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a clear chart showing monthly sales for three products with proper titles, legends, and axis labels.

📊 Data: You have monthly sales data for January to June for three products: Product A, Product B, and Product C.

🎯 Deliverable: Create a column chart with a chart title, legend identifying each product, and axis labels for months and sales amount.

Sample Data

Month	Product A	Product B	Product C
January	120	150	100
February	130	160	110
March	125	155	105
April	140	165	115
May	135	170	120
June	150	180	130

1

Step 1: Select the data range including headers and months (A1:D7).

Select cells A1 to D7.

Expected Result

Data range selected for chart creation.

2

Step 2: Insert a column chart using the selected data.

Go to Insert tab > Charts group > Insert Column or Bar Chart > Clustered Column.

Expected Result

A column chart appears showing sales for Product A, B, and C by month.

3

Step 3: Add a chart title describing the chart.

Click on the chart title area and type 'Monthly Sales for Products A, B, and C'.

Expected Result

Chart title is visible above the chart.

4

Step 4: Ensure the legend is visible and correctly identifies each product.

Check that the legend shows 'Product A', 'Product B', and 'Product C'. If not visible, enable it from Chart Elements (+ icon).

Expected Result

Legend appears on the right side of the chart with correct product names.

5

Step 5: Add axis labels: label the horizontal axis as 'Month' and the vertical axis as 'Sales Amount'.

Click Chart Elements (+ icon) > Axis Titles > Add Horizontal and Vertical Axis Titles. Then type 'Month' for horizontal and 'Sales Amount' for vertical.

Expected Result

Horizontal axis labeled 'Month' and vertical axis labeled 'Sales Amount'.

Final Result

Monthly Sales for Products A, B, and C

|      |      |      |      |      |      |
| 130  |  *   |  *   |  *   |      |      |
| 120  |  *   |  *   |  *   |      |      |
| 110  |  *   |  *   |  *   |      |      |
| 100  |  *   |  *   |  *   |      |      |
|      |----------------------------------
       Jan  Feb  Mar  Apr  May  Jun

Legend:
* Product A
* Product B
* Product C

✓Product B consistently has the highest sales each month.

✓Sales for all products generally increase from January to June.

✓Product C has the lowest sales but shows steady growth.

Bonus Challenge

Add data labels to each column to show exact sales numbers on the chart.

Show Hint

Click the chart, then click the Chart Elements (+ icon), check 'Data Labels' to display values on each column.