Why charts visualize data clearly in Excel - Dashboard Impact

Dashboard Mode - Why charts visualize data clearly

Dashboard Goal

Understand how charts help us see data patterns quickly and clearly.

Sample Data

Month	Sales	Expenses
Jan	1000	400
Feb	1200	450
Mar	900	420
Apr	1400	500
May	1300	480
Jun	1500	520

Dashboard Components

• KPI Cards: Show total sales and total expenses.
  Formulas:
  Total Sales: =SUM(B2:B7) (Result: 7300)
  Total Expenses: =SUM(C2:C7) (Result: 2770)
• Line Chart: Plots Sales and Expenses over Months to show trends.
  Data range: A1:C7
• Bar Chart: Compares Sales and Expenses side by side for each month.
  Data range: A1:C7
• Table: Shows raw data for reference.

Dashboard Layout

+----------------------+----------------------+
|      KPI Cards       |      KPI Cards       |
|  Total Sales: 7300   |  Total Expenses: 2770|
+----------------------+----------------------+
|                      Line Chart               |
|          (Sales & Expenses over Months)       |
+----------------------------------------------+
|                  Bar Chart                    |
|      (Monthly Sales vs Expenses Comparison)  |
+----------------------------------------------+
|                    Data Table                 |
|          (Months, Sales, Expenses)            |
+----------------------------------------------+

Interactivity

Add a filter for Month (e.g., show only Jan to Mar). When you select months, the KPI cards, line chart, bar chart, and data table update to show only data for those months. This helps focus on specific time periods.

Self Check

If you add a filter to show only months Apr to Jun, which components update?

• KPI Cards show totals for Apr, May, Jun only.
• Line Chart redraws to show trends for Apr to Jun.
• Bar Chart updates to compare Apr to Jun months.
• Data Table shows only Apr, May, Jun rows.

Key Result

A dashboard showing how charts and KPIs help visualize sales and expenses data clearly over months.