Why charts visualize data clearly in Excel - Business Case Study

Scenario Mode

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

📋 Request: Your manager wants you to show monthly sales data visually to help the team understand trends quickly.

📊 Data: You have monthly sales numbers for three products over six months.

🎯 Deliverable: Create a simple line chart in Excel that shows sales trends for each product over the six months.

Sample Data

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

1

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

Select cells A1 to D7.

Expected Result

The entire table with months and sales numbers is selected.

2

Step 2: Insert a line chart to visualize the sales trends.

Go to Insert tab > Charts group > Line Chart > Choose 'Line with Markers'.

Expected Result

A line chart appears showing sales trends for Product A, B, and C over the six months.

3

Step 3: Add chart title to explain what the chart shows.

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

Expected Result

The chart has a clear title describing the data.

4

Step 4: Add axis titles for clarity.

Select the chart, go to Chart Design > Add Chart Element > Axis Titles > Add 'Month' for horizontal axis and 'Sales' for vertical axis.

Expected Result

The chart shows 'Month' on the horizontal axis and 'Sales' on the vertical axis.

5

Step 5: Format the chart legend to show product names clearly.

Ensure the legend is visible and positioned at the bottom or right side of the chart.

Expected Result

The legend clearly identifies each product's line on the chart.

Final Result

Monthly Sales Trends for Products A, B, and C

Month | 120  135  150  160  170  180 (Product A)
      | 90   95   100  105  110  115 (Product B)
      | 100  110  115  120  130  140 (Product C)

(Line chart with three lines showing upward trends for all products over six months)

✓Sales for all three products increase steadily from January to June.

✓Product A has the highest sales numbers each month.

✓Product B has the lowest sales but shows consistent growth.

✓The chart makes it easy to compare sales trends at a glance.

Bonus Challenge

Create a bar chart instead of a line chart and compare which visualization better shows the sales trends.

Show Hint

Try inserting a clustered column chart using the same data range and observe how the bars represent monthly sales.