Excel Charts and Building Dashboards

When a three-dimensional, shadowed, seven-colour pie chart appears in a presentation, nobody in the room understands anything — yet everyone says "it's beautiful." A chart's job is not to look beautiful; it is to deliver one idea at one glance. By that criterion, most Excel charts need rebuilding.

Building Excel charts should be learned at two levels: the technical steps (these are easy) and the selection logic (the real difference lives here). This article has both: which chart for which data, how it is built, and when to move to a dashboard.

Which chart for which data?

The most violated rule concerns the pie chart: a circle with five or six slices cannot be read. When categories are many, a horizontal bar chart always wins; the names read comfortably and the comparison shows precisely.

Step by step: your first correct chart

• Select the data (headers included): the months and the sales figures.
• Insert → Recommended Charts; Excel's suggestions are usually sensible.
• Choose Line (it is a time series) → OK.
• Write a concrete title: not "Sales" but "H1 2026: monthly sales, thousand AZN".
• With Chart Elements (+), switch off the excess: gridlines to a minimum, and delete the legend entirely if there is one series.

The fifth step is the core of design: removing elements from a chart matters more than adding them. Every line, every colour, every label eats attention; anything not carrying the idea is excess.

Design rules: 5 conditions of a professional look

• One chart, one idea. If there are two ideas, build two charts.
• Colour is the message: the main series dark, the comparison background grey; no "every series its own colour" chaos.
• Let the axis start at zero (in column charts); a truncated axis artificially inflates differences and erodes trust.
• Renounce 3D effects: depth adds nothing and makes values harder to read.
• Show the number: in a chart with few categories, data labels work better than the axis.

A dynamic chart: let the chart grow as the source grows

The classic problem: a new month is added and the chart stays on the old range. The fix is one step: make the source a Table with Ctrl+T. Every row added to the table drops into the chart automatically. That habit saves hours of correction time in monthly report files.

A simple dashboard: three charts + a slicer

A dashboard is not a separate tool; it is orderly placement. The working recipe: keep the data on one sheet as a Table; build three key metrics from Pivot Tables (a trend, a split, a top list); create a chart from each pivot; lay them all out on a clean sheet; add one or two filter buttons with Insert → Slicer and connect them to all the pivots via Report Connections. The result: the boss clicks the filter and the three charts change together.

Let me state the boundary too: an Excel dashboard is excellent for in-team reporting; when multi-user, auto-refreshing, web-based panels are needed, moving up to the Power BI tier is right. Stretching Excel to that tier is possible, but inefficient.

Sources and further reading

Where to verify the source

Chart types and steps change little across versions; see the official documentation for the exact menus.

• Microsoft Support: Create a chart: the official setup guide
• Microsoft Support: Available chart types: the map of all chart types

Continuing the topic

Charts are data work's visible face; the foundations are in these articles:

• Pivot Tables: turn data into reports in seconds
• The most important Excel formulas
• What is Power BI? Build your first report
• Data analytics: entering the career
• Other articles on this topic

The test of a good chart is simple: can an outsider state the main idea within three seconds? If they cannot, the problem is not in their eyes — it is in the chart's construction.