How to create a chart in Excel (and pick the right one)

A chart turns a table of numbers into a shape you can read in a second. The hard part isn’t inserting one — Excel does that in a click — it’s picking the type that actually fits your data.

Step 1: Select your data

Include the header row along with the values. Excel uses the headers as labels and series names, so leaving them out just means retyping them later.

Step 2: Insert a chart

Go to Insert and either pick a chart type directly, or click Recommended Charts to let Excel suggest one based on the shape of your selection. Recommended Charts is worth using even once you know what you want — it’s a fast way to preview a few options side by side.

Which chart type to use

• Column or bar — comparing a value across categories (revenue by region). The default choice for most business data.
• Line — a trend over time (revenue by month). Don’t use it for unordered categories; a line implies a path between points that only makes sense along a timeline.
• Pie — one whole broken into a handful of shares. Falls apart past 5–6 slices — a bar chart reads better once there are more categories.
• Scatter — the relationship between two numeric variables (price vs. square footage). Not for categories or time.

Common mistakes

• Too many pie slices. If you’re squinting to tell two slivers apart, switch to a bar chart.
• A second (dual) axis. Mixing two scales on one chart makes it easy to imply a relationship between series that isn’t really there. Use it only when the units are genuinely incomparable, and label both axes clearly.
• 3D effects. They distort the actual proportions — a “bigger-looking” slice or bar isn’t necessarily a bigger number. Stick to 2D.
• No axis titles. A chart with unlabeled axes forces the reader to guess what they’re looking at.

Quick cleanup

Click the chart, then use the Chart Elements (+) button to add a chart title and axis titles, or remove clutter like gridlines and a legend the chart doesn’t need. A chart with one clear takeaway is usually better than one crammed with every available label.

If you’re charting a summary you built with a pivot table, Excel can generate a PivotChart directly from it — same idea, but it stays linked to the pivot table’s fields instead of a fixed range.