Formatting chart appearance in Excel - Dashboard Guide

Dashboard Mode - Formatting chart appearance

Dashboard Goal

Show monthly sales data with a clear, colorful chart that is easy to read and understand.

Sample Data

Month	Sales
January	1200
February	1500
March	1700
April	1600
May	1800
June	2000

Dashboard Components

• KPI Card: Total Sales
  Formula: =SUM(B2:B7)
  Result: 9800
• Column Chart: Monthly Sales
  Data Range: A2:B7
  Formatting:
  • Chart Title: "Monthly Sales"
  • Bar Colors: Blue bars
  • Axis Titles: X-axis "Month", Y-axis "Sales ($)"
  • Data Labels: Show sales values on top of bars
  • Gridlines: Light gray horizontal gridlines for easier reading

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |                      |
|        9800          |   Monthly Sales Chart |
|    (KPI Card)        |                      |
+----------------------+----------------------+

Interactivity

This dashboard is static for formatting practice. In a real scenario, you could add a filter for months or regions to update the chart and total sales automatically.

Self Check

If you change the bar color to green in the chart formatting, which component updates?

• The Column Chart will update to show green bars.
• The Total Sales KPI remains the same.

Key Result

Dashboard showing total sales and a formatted monthly sales column chart with clear labels and colors.