Data bars in Excel - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a quick visual summary of monthly sales performance for each product to identify top sellers easily.

📊 Data: You have a table listing products and their total sales for the month.

🎯 Deliverable: Create a report with data bars in the sales column to visually show sales amounts.

Sample Data

Product	Sales
Apples	1200
Bananas	850
Cherries	600
Dates	400
Elderberries	300
Figs	950
Grapes	1100
Honeydew	700

1

Step 1: Select the sales data cells from B2 to B9.

No formula needed; just select cells B2:B9.

Expected Result

Cells B2 to B9 are highlighted.

2

Step 2: Apply data bars conditional formatting to the selected sales cells.

Go to Home tab > Conditional Formatting > Data Bars > Choose a solid fill color (e.g., blue).

Expected Result

Each sales cell shows a horizontal bar proportional to its value.

3

Step 3: Check that the longest bar corresponds to the highest sales value (1200 for Apples).

No formula; visually confirm the bar length.

Expected Result

Apples cell has the longest data bar; other bars scale accordingly.

Final Result

████████████████

↓

███████████

↓

████████

↓

█████

↓

████

↓

██████████

↓

█████████████

↓

████████

✓Apples are the top-selling product with the highest sales and longest data bar.

✓Elderberries have the lowest sales and shortest data bar.

✓Data bars provide a quick visual comparison of sales performance across products.

Bonus Challenge

Add color-based data bars that change color based on sales thresholds: green for sales above 1000, orange for sales between 600 and 1000, and red for sales below 600.

Show Hint

Use Conditional Formatting > New Rule > Format all cells based on their values > Choose 'Data Bar' and set different rules with 'Manage Rules' for color changes.