How to make a chart
in Excel, step by step

Choosing the right chart type

The chart type determines what question you're answering. Choosing the wrong type doesn't just look bad — it actively misleads.

• Bar or column chart — comparing values across categories (sales by region, headcount by department). Column is vertical, bar is horizontal. Both work for the same data; use horizontal bars when category labels are long.
• Line chart — showing how a value changes over time. Revenue by month, temperature by day. The line implies continuity between points, so only use it for time series data.
• Pie chart — showing each category as a share of the total. Only use it when you have fewer than 6 slices and the proportions genuinely matter. Pie charts are almost always harder to read than a simple bar chart.
• Scatter chart — showing the relationship between two numeric variables. Do higher marketing spends correlate with more sales? Scatter plots answer that question.

Creating your first chart

Formatting and labeling

Add a chart title

Click directly on the "Chart Title" placeholder and type your title. Make it describe what the chart shows, not just repeat the data source: "Q2 Revenue by Region" is better than "Sales Data".

Add data labels

Right-click any bar or line → Add Data Labels. This puts the exact value on each data point. Useful when the precise number matters, but can clutter a chart with many data points.

Change colors

Chart Design tab → Change Colors, or click individual bars/lines and use the Format tab to set a specific fill color. Keep your color scheme consistent — the same region should always be the same color across multiple charts.

Keeping charts updated

Excel charts are linked to their source data. Change a value in the spreadsheet and the chart updates automatically — no rebuilding needed.

If you add new rows or columns of data after creating the chart, the chart won't include them automatically. Right-click the chart → Select Data → expand the range to include the new data.

The clean fix: convert your source data to an Excel Table first (Ctrl + T). Charts built from Tables automatically expand to include new rows — no manual range editing.

Common mistakes

Too many data series on one chart

More than 5-6 lines or bar groups on one chart becomes unreadable. Split into multiple charts, or use a summary table instead.

Starting the Y-axis at a value other than zero

Excel sometimes starts the axis at a non-zero value to make small differences look dramatic. Right-click the axis → Format Axis → set Minimum to 0 for any comparison chart where you don't want to mislead.

Using a line chart for non-time data

A line chart implies that values between the plotted points exist and are continuous. Revenue by month is appropriate — the line implies gradual change over time. Headcount by department is not — there is no sensible "value between departments".