Before you chart: clean your data
How to create charts in Excel starts with tidy headers and no duplicate summary rows. If you merged exports from several files, run Excel Merge then Remove Duplicates so totals are not doubled.
Create a column chart (fastest path)
- Select data including headers (e.g. Month + Revenue).
- Insert → Recommended Charts or Insert → Column Chart.
- Click Chart Title and axis labels to edit text.
- Use Chart Design → Add Chart Element for data labels or legend position.
Line vs pie vs bar
| Chart | Use when |
|---|---|
| Column/Bar | Compare categories |
| Line | Trends over time |
| Pie | Parts of a whole (few slices) |
Common mistakes
- Including grand total row → chart spike at the end.
- Mixed text/numbers in value column → fix with Date/Text convert if needed.
- Too many categories → filter top N or use pivot table first (pivot guide).
Need formulas for chart source data?
Use Formula AI for SUMIFS or growth rates feeding your chart range.