1
00:00:00,080 --> 00:00:04,954
Our fictional report has an April revenue row, yet its chart ends at March.

2
00:00:04,954 --> 00:00:06,694
April is four hundred dollars.

3
00:00:06,694 --> 00:00:10,872
We will expand the chart's selected source to include row five,

4
00:00:10,872 --> 00:00:15,397
then check both the fourth plotted category and the twelve-hundred-dollar total.

5
00:00:15,997 --> 00:00:18,988
Open the practice CSV in a workbook copy.

6
00:00:18,988 --> 00:00:23,101
January is two hundred, February is three hundred fifty, and March

7
00:00:23,101 --> 00:00:24,970
is two hundred fifty dollars.

8
00:00:24,970 --> 00:00:27,214
Their starting total is eight hundred.

9
00:00:27,214 --> 00:00:31,326
Select both columns with headers and make a simple column chart

10
00:00:31,326 --> 00:00:33,943
so the initial three categories are visible.

11
00:00:34,543 --> 00:00:38,849
Select the three-month chart and open its data or source settings.

12
00:00:38,849 --> 00:00:43,155
The selected cells end at row four: headers plus January through March.

13
00:00:43,155 --> 00:00:47,102
That explains why a value in row five cannot appear yet.

14
00:00:47,102 --> 00:00:50,331
Keep the chart selected while you inspect the range.

15
00:00:50,931 --> 00:00:55,515
Enter April in A5 and four hundred in B5, directly below March.

16
00:00:55,515 --> 00:01:00,098
Then change the chart's selected source from A1 through B4 to

17
00:01:00,098 --> 00:01:02,390
A1 through B5 and apply it.

18
00:01:02,390 --> 00:01:07,355
Microsoft documents editing the chart's source selection when more data is added.

19
00:01:07,955 --> 00:01:13,454
The updated chart should gain April as its fourth category with a four-hundred-dollar value.

20
00:01:13,454 --> 00:01:17,234
Add all four months independently: two hundred plus three hundred fifty

21
00:01:17,234 --> 00:01:20,671
plus two hundred fifty plus four hundred equals twelve hundred.

22
00:01:20,671 --> 00:01:25,139
A fourth bar with the wrong label or height is not a pass.

23
00:01:25,739 --> 00:01:29,610
If April is missing, confirm A5 and B5 contain the new

24
00:01:29,610 --> 00:01:34,538
month and value, then check whether the chart still points to A1 through B4.

25
00:01:34,538 --> 00:01:38,410
Extend the source to row five and inspect any chart filter

26
00:01:38,410 --> 00:01:41,578
that might hide April before repeating the visual check.