FormulaCamp
Completed
All Excel how-to articles
Practical Excel how-to

How to Create Charts in Excel

Create charts in Excel step by step, choose the right chart type, add useful labels, build a combo chart, and fix common chart-data errors.

Create a chart step by step

Start with a compact rectangular range: one header row, categories or dates in the first column, and one or more numeric series beside it. Avoid selecting totals unless they belong in the comparison. Select the range, open Insert, and choose the chart family. Excel inserts an embedded chart that remains linked to those cells.

Move or resize the chart without covering the data you still need to inspect. Replace the generic title with the question the chart answers, such as “Monthly revenue, 2026.” Use Chart Design > Select Data if Excel treated row headings as series, omitted a range, or placed the wrong labels on the horizontal axis. Switch Row/Column can fix orientation, but verify the result rather than accepting it blindly.

Choose the right chart type

Use a column chart for comparing a small number of categories. A horizontal bar chart is easier when category names are long. Use a line chart for a sequence over time, with dates in chronological order. Use an XY scatter chart when both axes are numeric and the spacing between x-values matters; a line chart treats its horizontal positions as categories.

Pie and doughnut charts work only for a few nonnegative parts of one meaningful whole, and precise comparisons are still easier in bars. Stacked columns show composition and totals, while 100% stacked columns compare proportions and hide absolute size. Avoid 3-D effects because perspective makes lengths and areas harder to compare.

Titles, axes, labels, and legends

A chart title should state the measure, grouping, and period when those are not obvious. Add an axis title when the unit is not visible in the number format. Format currency, percentages, and decimals consistently with the source. Do not truncate a bar or column axis merely to exaggerate small differences; when a nonzero baseline is necessary, make the scale conspicuous.

Data labels are useful for a small set of important points but become clutter on every point of a dense line. A legend is unnecessary for one clearly named series. Direct labels can be clearer for two or three lines. Keep gridlines light, use color consistently, and ensure the meaning does not depend on red versus green alone.

Build a combo chart

A combo chart is useful when two series need different forms, such as revenue as columns and margin percentage as a line. Select the full range, choose Insert > Combo Chart, assign the desired type to each series, and use a secondary axis only when the units genuinely differ. Label both axes because two scales can otherwise invite a false visual comparison.

Do not add a secondary axis merely because one series is smaller. First consider indexing both series, showing two aligned charts, or changing units. If you use two axes, inspect their bounds after data updates: automatic scaling can make unrelated movements appear synchronized.

Common chart errors

Blank charts and missing points often trace back to numbers stored as text, hidden filters, or a source range that excludes new rows. Convert the range to an Excel Table if the chart should expand as rows are appended. A line that jumps across missing periods may be connecting blanks; open Select Data > Hidden and Empty Cells and choose the treatment that matches the meaning of the data.

Wrong category labels come from selecting mismatched ranges or including an extra header row. Dates displayed at equal spacing may be text rather than real dates, or the axis may be a text axis. Duplicate categories are not automatically consolidated: summarize the records first with formulas or a PivotTable. Before charting B2:B4, a check such as =SUM(B2:B4) can confirm the visible source total. The live sheet below checks source values only; FormulaCamp’s sheet does not render Excel charts.

Your turn

In D2, total the revenue values that will feed the chart.

Example spreadsheet for monthly chart source
ABCD
1MonthRevenueCostRevenue total
2Jan12080
3Feb15095
4Mar13590
Not yet solved.

Worked example

Monthly revenue and cost in A1:C4. These formulas verify the source values before they are charted; chart creation remains an Excel interface task.

ABC
1MonthRevenueCost
2Jan12080
3Feb15095
4Mar13590
FormulaResult
=SUM(B2:B4)405
=SUM(C2:C4)265
=B3-C355
=MAX(B2:B4)150

Quick mistake checklist

  • Selecting totals or unrelated notes as part of the chart source.
  • Using a line chart when numeric x-value spacing requires a scatter chart.
  • Adding labels, colors, and 3-D effects that obscure the comparison.
  • Using a secondary axis without clearly labeling both scales.

Frequently asked questions

How do I create a chart in Excel?

Select a clean range containing headers, category labels, and numbers; choose Insert and a chart type; then verify the series and labels in Select Data.

Which chart type should I use?

Use columns or bars for category comparisons, lines for ordered time series, and XY scatter when both axes are numeric.

How do I make a chart update with new rows?

Base it on an Excel Table, or expand its source range through Chart Design > Select Data.

When should I use a combo chart?

Use one when related series benefit from different forms, such as columns and a line. Use a secondary axis only for genuinely different units, and label both scales.

Practice the skill

Continue with a checked FormulaCamp lesson: Charts Free

Open the free lesson