Try the example, then check the result.
Download the fictional material and follow the steps below. The video uses English illustrative diagrams; it does not present a live app recording. Product controls may vary by version.
Check the answer before applying the method to your own data. How we review guides ↗
Watch the complete lesson.
The video uses English illustrative diagrams; it does not present a live app recording. English captions. Product menus may differ in your account.
Quick answer. Enter April $400 directly below March, select the chart, and expand its source from A1:B4 to A1:B5. Confirm April plots as the fourth category at $400.
Use the fictional practice file: monthly-chart-practice.csv, plus the independent answer check. Work in a copy. This guide stands on its own without the video.
Scope and limits. The chart source range must include the new row. In Excel for the web, inspect your chart pane and verify that April appears; menu wording may vary by version.
1. Check the three starting values
Open monthly-chart-practice.csv in an Excel for the web workbook copy. A1:B4 contains Month and Revenue USD with January $200, February $350, March $250. Make a simple column chart from this range and verify exactly three categories before changing the source.
Checkpoint: January $200, February $350, March $250; total $800.
2. Identify the chart's current source
Select the chart and inspect its data source. The original source should cover A1:B4, including headers and three month rows. In Excel for the web, the chart task pane may show Data > Source; desktop Excel may show Chart Design > Select Data.
Checkpoint: Current selected source ends at row 4.
3. Add April and extend the source
Type April in A5 and 400 in B5. With the chart selected, edit its source range to A1:B5 and apply. The exact menu label depends on your Excel version; inspect the chart task pane or Chart Design > Select Data. Keep both Month and Revenue columns included.
Checkpoint: Updated chart source is A1:B5.
4. Verify the chart and independent total
Inspect the actual chart, not just the data cells. It should show January $200, February $350, March $250, April $400. Sum those values independently to get $1,200. Do not call the chart fixed unless both the category and value are correct.
Checkpoint: Four categories; April $400; total $1,200.
Verify the result
The initial three values total $800. After adding April $400 in row 5, the expected four-month total is $1,200 and the chart must show April as its fourth category at $400. A chart that still ends in March fails the check.
If it still does not work
If April exists in A5:B5 but is absent from the chart, inspect the chart source and extend it to A1:B5. If the source already includes row 5, confirm April is not hidden by a chart filter. Do not claim the issue is fixed until April visibly plots.
Official sources
- Select data for a chart (checked 26 October 2026).
- Create a chart from start to finish (checked 26 October 2026).
- Update the data in an existing chart (checked 26 October 2026).
Any instructional panel without a marked actual-app capture is an illustrative diagram of the fictional exercise.
Practice downloads.
The exercise files contain invented information. Save a local copy before editing.