Proper Excel Chart Creation: A Step-by-Step Guide

To create a proper chart in Excel for Microsoft 365 on Windows, arrange your data in a clear table with meaningful headers, select the range, then choose Insert > Recommended Charts and pick a chart that fits the comparison you want to show. Add a precise title, check the axes and labels, and make sure the finished chart communicates the data accurately rather than merely looking attractive.

Prepare the Data Before You Chart It

A chart is only as reliable as the data behind it. Put each variable in its own column, use one header row, and keep each observation on its own row. For example, a monthly sales table might have Month, North, and South as column headings, followed by one month and two sales values on each row. This layout makes it easier for Excel to identify categories and series correctly.

Use short, descriptive column headers rather than blank cells or repeated title rows.
Keep each column consistent: dates in the date column, numbers in value columns, and text labels in category columns.
Do not merge cells in the chart source range. Merged headings can confuse selection and make the source harder to maintain.
Keep totals and notes outside the data block, or clearly separate them, so they are not mistaken for another observation.
Use actual numeric values for measurements. A number stored as text may not plot as expected.

If the data will grow over time, consider converting it to an Excel table. Select a cell in the data and choose Insert > Table, confirm that the table has headers, and select OK. A chart based on a table can include newly added table rows more conveniently than a chart tied to a fixed cell range. Check the chart after adding data, especially if the workbook uses unusual layouts or separate source ranges.

Choose a Chart That Matches the Question

Choose a chart based on what the reader needs to compare. A familiar chart is not automatically the right chart: a pie chart, for example, is poor at showing change over time, while a line chart can imply continuity between categories that have no meaningful order.

Column or bar: Compare values among categories. Use columns for a short category list or a time sequence with discrete periods; use horizontal bars when category names are long.
Line: Show a trend across ordered values, especially dates or time periods. Multiple lines can compare series, provided the lines remain distinguishable.
Scatter (X, Y): Examine the relationship between two numeric variables. Unlike a standard line chart, a scatter chart positions points according to numeric values on both axes.
Pie or doughnut: Show parts of one whole when categories are mutually exclusive and there are only a few meaningful slices. If slices are similar in size or numerous, a bar chart is usually easier to compare.
Area: Emphasize how values or totals change over an ordered sequence. Overlapping filled areas can obscure series, so use this format carefully.

For instance, to compare the monthly sales of two regions, a line chart can show how each region changes over the year. To compare total annual sales among ten regions, a sorted bar chart is often easier to scan. If the question is whether advertising spend is associated with sales, a scatter chart is more suitable than a line chart because both measures are numeric.

Create the Chart in Excel

For a standard chart, first select the data, including its headers. Then choose Insert > Recommended Charts. Review the suggested chart types and select one to preview it; choose OK to insert it into the worksheet. Recommended Charts is a starting point, not a guarantee that Excel has inferred your intention correctly. Check whether the categories and series are arranged as you expect.

Select the chart, then open the Chart Design tab on the ribbon. Use Change Chart Type if you need a different chart, or Switch Row/Column if Excel has treated rows as series when you intended them to be categories, or vice versa.
Use Chart Design > Add Chart Element to add or change items such as a chart title, axis titles, data labels, gridlines, or a legend. The available elements depend on the chart type.
Move or resize the chart using its border handles. To place it on a separate chart sheet, choose Chart Design > Move Chart.
Click outside the chart when finished, then review it at a useful size. A chart that looks clear only when enlarged may be difficult to read in a report or presentation.

You can also use Insert > Recommended Charts without selecting a range first, but Excel may ask you to choose data. Selecting the intended range in advance usually makes the source easier to verify. On Excel for Mac, the same general workflow is available through the Insert and Chart Design tabs, although ribbon placement and dialog appearance can vary by release. Excel for the web has chart insertion and formatting tools too, but some advanced chart controls may differ from the Windows desktop version.

Make Titles, Axes, and Labels Informative

A useful chart title tells readers what is being measured and, where relevant, the period or scope. Sales by region is more informative than Chart 1. If the values are in thousands of dollars, say so in an axis title or in a clear subtitle rather than expecting readers to infer the units. Avoid repeating the same information in the title, legend, and every data label.

Axis scales deserve particular attention. For a column or bar chart, a vertical value axis that starts above zero can make modest differences appear much larger than they are. A zero baseline is generally appropriate for comparing bar lengths. Line charts can sometimes use a narrower scale to show variation, but make the scale evident and consider whether the visual emphasis could mislead. For dates, check that Excel is displaying a sensible time scale and that labels do not overlap.

Data labels are helpful when readers need exact values or when there are only a few points. They can clutter a chart with many categories. If a chart has a legend, keep the series names concise and meaningful. For a single series, a legend may add little; remove it if it does not help interpretation. Use axis titles when the measurement or units would otherwise be unclear.

Format for Clarity and Accessibility

Formatting should make patterns easier to see, not compete with them. Use a restrained palette, give each series a distinct color, and avoid relying on color alone to distinguish important information. Line styles, markers, direct labels, or patterns can help readers who have difficulty distinguishing colors. Check that text remains legible at the size where the chart will actually be used.

Remove decorative effects that do not carry meaning, such as unnecessary 3-D perspective. Three-dimensional charts can distort apparent size because perspective changes how bars or slices look. Light gridlines can help readers estimate values, but too many gridlines create visual noise. Keep backgrounds and borders simple, and format numbers consistently: for example, use the same currency symbol and decimal precision across comparable values.

Give a chart meaningful alternative text when it will be shared with readers who use assistive technology. In current Microsoft 365 desktop versions, right-click the chart and choose View Alt Text if that command is available, then provide a concise description of the chart’s purpose and main takeaway. A chart’s title and alt text serve different needs: the title labels the graphic, while alt text helps convey its content in context. For complex charts, include the underlying data in an accessible table as well.

Check the Data Range and Keep Charts Updated

To inspect or change a chart’s source, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, review the chart data range, legend entries (series), and horizontal category labels. This is useful when a chart has omitted a row, included a total, or assigned the wrong labels. The Switch Row/Column button in the same area can correct a reversed interpretation.

When values in the source cells change, a normal chart linked to those cells generally updates with them. Adding new observations is a separate issue: a fixed-range chart may not include rows placed beyond its current source range. Using an Excel table as the source often makes additions easier to incorporate. When you paste new data, confirm that the chart includes the new categories and that formulas or table formatting have not left gaps in the intended data.

Charts can also be affected by hidden rows or columns. In the Select Data Source dialog, choose Hidden and Empty Cells to review how hidden data and blanks are displayed. The available empty-cell choices can include showing gaps, zeros, or connecting data points, depending on the chart. Choose the treatment that matches the meaning of the missing values; a blank should not automatically be treated as zero if no measurement was recorded.

Common Chart Problems and Practical Fixes

Excel plots the wrong series: Check the selected range and use Chart Design > Switch Row/Column. Also check whether headers were included as the first row or column.
Numbers appear as categories or are missing: Check whether the source cells contain numbers or numbers stored as text. Review the range in Select Data and remove accidental blank rows or explanatory text from the chart source.
The chart shows an unexpected total: Make sure a totals row was not included as if it were another category. Totals can be useful in a table but may distort a comparison of individual categories.
Labels overlap: Widen the chart, reduce label detail, switch to a horizontal bar chart for long category names, or show labels only for selected points where possible.
The trend looks exaggerated: Inspect the value axis bounds and units. For bar charts, consider whether the vertical axis should start at zero; for all charts, disclose a nonstandard scale clearly.
Blank dates or gaps appear: Confirm that the source data has the expected dates and values. Review Hidden and Empty Cells rather than filling blanks with zero without justification.

A common misconception is that Excel’s default chart is necessarily the best one. Defaults can produce a reasonable first draft, but they cannot know the audience, the question, or whether a missing value means zero or unknown. Treat the first chart as a draft and verify its source, scales, labels, and visual message before sharing it.

Frequently Asked Questions

How do I make a chart in Excel from two columns?
Select both columns, including their headers, then choose Insert > Recommended Charts and select a suitable chart. If one column contains categories and the other contains values, a bar or column chart is often a sensible starting point.

How do I change the data used by an Excel chart?
Select the chart and choose Chart Design > Select Data. Edit the chart data range or adjust the series and category labels in the dialog, then confirm the change and check the result.

How do I add a title and axis labels?
Select the chart, choose Chart Design > Add Chart Element, and select Chart Title or Axis Titles. Enter wording that identifies the measurement and units without leaving readers to guess.

Why does my Excel chart not include new rows?
The chart may be based on a fixed cell range that ends before the new rows. Use Chart Design > Select Data to extend the range, or consider making the source an Excel table so added rows can be included more conveniently.

Which Excel chart is best for comparing categories?
A bar or column chart is a good general choice. Use bars when category labels are long, and sort categories when an ordered ranking makes the comparison easier to understand. The best choice still depends on the data and the question.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.