0
0
Excelspreadsheet~8 mins

Data bars in Excel - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - Data bars
Dashboard Goal

Show sales performance visually using data bars to quickly see which products sold more.

Sample Data
ProductSales
Apples120
Bananas80
Cherries150
Dates60
Elderberries100
Dashboard Components
  • Sales Table with Data Bars: Shows product names and sales numbers. The Sales column uses Excel's conditional formatting with data bars to visually represent sales amounts. Formula: No formula needed; apply conditional formatting > Data Bars on Sales column (B2:B6).
  • Total Sales KPI: Displays total sales value. Formula: =SUM(B2:B6) Result: 510
  • Average Sales KPI: Displays average sales per product. Formula: =AVERAGE(B2:B6) Result: 102
Dashboard Layout
+----------------------+------------------+
| Total Sales: 510     | Average Sales: 102|
+----------------------+------------------+
| Product     | Sales     |
|------------------------|
| Apples      | ▓▓▓▓▓▓▓▓▓▓ 120 |
| Bananas     | ▓▓▓▓▓▓     80 |
| Cherries    | ▓▓▓▓▓▓▓▓▓▓▓▓ 150 |
| Dates       | ▓▓▓▓▓       60 |
| Elderberries| ▓▓▓▓▓▓▓    100 |
+------------------------+
Interactivity

Add a filter for Product category or date range (if available). When a filter is applied, the Sales Table updates to show only matching products, and the Total Sales and Average Sales KPIs recalculate based on filtered data.

Self Check

If you add a filter to show only products with sales above 90, which components update?

  • The Sales Table will show only Apples, Cherries, and Elderberries.
  • Total Sales KPI will update to 370 (120 + 150 + 100).
  • Average Sales KPI will update to 123.33 (370 divided by 3 products).
Key Result
Dashboard shows product sales with data bars and key sales metrics.