Microsoft Excel · Analysis and charts · Beginner
Create and Edit a Chart in Excel
Choose and build a chart for comparisons, trends and proportions; Maintain chart data, labels and axes as records grow in Excel with a complete practice example, expected results and recovery checks.
Official documentation reviewed; example logic independently checked; native Excel execution not performed · Editorial standards
Quick answer: Select a labeled data range, insert a chart and verify its category and series assignments. When you add records, inspect the chart’s source range; a chart that correctly updates an existing value can still omit a newly added row.
Version and platform: Microsoft 365 Excel for Windows desktop; Mac, Excel for the web and Excel 2013 interfaces not covered. Use a disposable workbook for the exercise.
Prepare four months of data
In a blank worksheet enter this table at A1:B5:
| Month | Orders |
|---|---|
| January | 12 |
| February | 16 |
| March | 14 |
| April | 20 |
The total is 62, but do not add that total as a fifth month. The intended chart has one series named Orders and four categories in the order shown. A clustered column chart compares monthly quantities clearly. A line chart is another reasonable choice when the trend over time is the main message. A pie chart emphasizes proportions of a whole, but makes these month-to-month comparisons harder; choose the form to answer the question, not because it looks decorative.
Create and label the chart
- Select A1:B5, including the labels.
- Choose Insert → Recommended Charts and preview the choices. Select a clustered column chart; if it is not suggested, use All Charts to choose the column type.
- Confirm with OK. Inspect the category labels January through April and the single Orders series before adjusting colors.
- Edit the chart title to Orders by month. Keep a readable value axis and check that its scale represents 12, 16, 14 and 20 honestly.
- If Excel created several series or used the wrong labels, inspect the source selection instead of styling the incorrect interpretation. The heading Orders is a label, not a data point.
For this quantity comparison, a zero baseline is easier to interpret than a tightly cropped scale that exaggerates small differences. Make sure the chart is large enough to show all four month names. An unnecessary three-dimensional effect or a busy legend is not useful for one series.
Verify a changed value
Change B5 from 20 to 10. April’s column must become shorter than January’s 12, while the other three remain unchanged. The source total is now 52. If April does not change, inspect whether the chart is actually linked to A1:B5 rather than being a pasted picture. Restore B5 to 20 before continuing.
Include a newly added record
Enter May and 18 in A6:B6. Do not assume a chart based on a fixed range now includes it. Select the chart and inspect its data selection. For the documented range-expansion method, use the chart’s highlighted source range and drag its sizing handle to include row 6. Confirm that the range includes A1:B6 and that both the month label and the amount were added, not just one column.
The completed chart should have five categories, with May at 18 and the previous four unchanged. The source total is 80. Change B6 to 22: May should update and become the tallest column, while April stays at 20. If May is absent, the range still stops at row 5; editing B6 cannot repair that omission by itself.
Save and troubleshoot
Save as XLSX so the editable chart and source cells stay together. Reopen the workbook, select the chart and confirm the five categories and final values 12, 16, 14, 20, 22. Their total is 84. If amounts behave like labels, check that B2:B6 contains numbers rather than imported text. If categories are reversed or duplicated, fix the data orientation and source range first. Revisit label readability whenever records grow: a technically complete chart can still be unusable if every category label overlaps.
Official references
- Creating charts from start to finish
- Create a chart from start to finish
- Update the data in an existing chart
- Add a data series to your chart
Documentation snapshots retrieved 20 October 2026. These instructions and example checks are documentation-based; no native Excel run or application screenshot is claimed.