Creating Professional Charts and Visualisations in Excel

A chart should communicate an insight in seconds. Most Excel charts fail because they use the wrong chart type, have too much clutter, or lack clear formatting. Here's how to create charts that actually tell a story.

Choosing the Right Chart Type

Data Story	Best Chart	Avoid
Comparison across categories	Bar/Column chart	Pie chart (if >5 categories)
Trend over time	Line chart	Pie chart
Part-of-whole	Pie/Donut (≤5 items)	3D charts
Distribution	Histogram	Bar chart
Correlation	Scatter plot	Line chart
Comparison + composition	Stacked bar chart	Multiple pie charts

Creating a Chart

1. Select your data (including headers)
2. Go to Insert → choose your chart type
3. Or press Alt+F1 for a quick default chart

Professional Formatting Rules

1. Remove Clutter

• Delete gridlines (or make them very light grey)
• Remove chart borders
• Remove the legend if there's only one data series
• Delete the chart title if you're adding your own text box

2. Use Colour Intentionally

• Use one accent colour for the main data, grey for everything else
• Highlight the key insight with a contrasting colour
• Never use more than 5-6 colours in one chart
• Avoid rainbow colour schemes — they don't convey meaning

3. Format Numbers

• Abbreviate large numbers: "50K" not "50,000"
• Remove unnecessary decimal places
• Add currency symbols or percentage signs to axis labels

4. Add Context

• Add a clear, descriptive title that states the insight: "Revenue grew 23% YoY" not just "Revenue"
• Add data labels to the most important bars/points
• Add reference lines for targets or averages

Chart Formatting Shortcuts

• Double-click any chart element to format it
• Click a chart → use the + icon to add/remove elements (title, legend, data labels, gridlines)
• Right-click axis → Format Axis → change min/max values, number format
• Use Chart Design tab → Change Colours for predefined palettes

Advanced Techniques

Combination Charts

Show two data series with different scales — e.g., revenue as bars on the primary axis, and profit margin as a line on the secondary axis. Right-click a series → Change Series Chart Type → check "Secondary Axis".

Sparklines

Tiny inline charts that fit inside a single cell. Insert → Sparklines → choose Line, Column, or Win/Loss. Perfect for showing trends in tables without full-sized charts.

Dynamic Chart Range

Use an Excel Table as your chart data source. When new rows are added to the table, the chart automatically expands to include them.

Common Chart Mistakes

1. 3D charts — They distort data perception. Always use 2D.
2. Pie charts with too many slices — Maximum 5. Use a bar chart for more categories.
3. Truncated axes — Starting a bar chart at a value other than 0 exaggerates differences.
4. Missing labels — Every chart needs a title, axis labels, and a data source.