Stop 02 · Excel & SpreadsheetsTopics · 6/10

Excel Charts & Dashboards

In short

A one-page Excel dashboard is often the first thing a manager sees from you. Make it clean and focused, and they'll trust the numbers on it.

Building clear, focused charts and combining several into a single-sheet dashboard view — the same visualization principles from Phase 5, applied inside Excel specifically.

The jaadu pins simple bar, line and pie chart cards onto a corkboard.

Think of it like this

The hostel notice board

A good notice board has a few clear notices pinned where everyone looks: mess timings, exam dates, the one urgent alert. A cluttered board gets ignored. An Excel dashboard is your notice board, so pin only the charts people need.

Watch it happen

Building a one-sheet dashboard

Data sheet

Pivots

Charts

Dashboard

Slicers

1/5Raw data lives on its own sheet as a formatted Table. Nobody edits it by hand.

The big ideas

What you need to know

Separate data, calc and view

Three sheets: raw data, calculations, dashboard. It keeps things tidy and easy to update.

Slicers make it interactive

A slicer is a set of buttons that filters connected pivots and charts together.

Remove the defaults

Delete gridlines, extra legends and 3D effects. Add clear titles that state the takeaway.

Save yourself the pain

Common mistakes

Oops

Putting twelve charts on one sheet because you can.

Do this instead

Answer three to five key questions. If a chart doesn't drive a decision, cut it.

Oops

Chart titles like 'Sum of Sales by Month'.

Do this instead

Write the point: 'Sales dipped in June, recovered by August'.

Your mission

A three-chart dashboard

~40 min

Quick check

You want one click to filter three charts by region. What do you add?

Go deeper

1Build a one-sheet dashboard with 3-4 charts summarizing a sample dataset.
2Learn to use named ranges and dropdowns to make a dashboard interactive.
3Avoid 3D charts and excessive colors — clarity beats visual flourish.