1
00:00:00,970 --> 00:00:05,190
Let's take a look at creating dynamic chart ranges with Excel tables.

2
00:00:05,260 --> 00:00:10,360
Here I have profit information for the productivity division by month.

3
00:00:10,420 --> 00:00:14,460
This time I'm going to highlight it and insert a line chart.

4
00:00:14,470 --> 00:00:21,180
So from the chart options here I'm going to click on 2D line and select the first option in there.

5
00:00:21,230 --> 00:00:27,630
As a first step I'm going to connect the title to A3 right here. I'm going to click on the title,

6
00:00:28,000 --> 00:00:33,670
immediately go to the formula bar, type in equal and click on cell A3.

7
00:00:33,670 --> 00:00:37,760
What happens when I add next month's data to this?

8
00:00:37,780 --> 00:00:39,720
Let's say we're in October now.

9
00:00:39,880 --> 00:00:41,900
I'm going to go with 12,000.

10
00:00:41,920 --> 00:00:46,430
It doesn't pop up in here. For me to get it added to the chart.

11
00:00:46,450 --> 00:00:50,630
I actually have to expand that chart range.

12
00:00:50,730 --> 00:00:56,050
Now this is where you can work with tables. Because that's going to make that whole process dynamic

13
00:00:56,530 --> 00:01:01,690
without you having to do anything. Let's just press Control+Z to go back.

14
00:01:01,720 --> 00:01:08,410
Now before I add my data to this, I'm going to make one simple tweak. That's to transform this dataset

15
00:01:08,740 --> 00:01:10,300
into an official Excel tables.

16
00:01:10,300 --> 00:01:16,380
I'm going to click anywhere inside the dataset and use the shortcut key Control+T.

17
00:01:16,510 --> 00:01:18,890
Excel wants to know if my table has headers.

18
00:01:19,000 --> 00:01:20,130
Well, it does.

19
00:01:20,140 --> 00:01:27,140
It doesn't have any specific header here but watch what happens if you haven't specified any header.

20
00:01:27,160 --> 00:01:29,970
Excel gives its own standard header to this.

21
00:01:30,010 --> 00:01:33,280
I'm going to change this to month.

22
00:01:33,280 --> 00:01:40,480
The only thing I don't like is the formatting here. I'm going to go to the style options and take away

23
00:01:40,480 --> 00:01:44,100
that format to go back to my own formatting.

24
00:01:44,110 --> 00:01:46,710
Notice this is now an official Excel table.

25
00:01:46,720 --> 00:01:50,360
What happens when I add October data to this?

26
00:01:50,470 --> 00:01:53,170
I see October pop up in the chart.

27
00:01:53,410 --> 00:02:00,910
Let's go with 12,500 and that is automatically added here. And my table expands,

28
00:02:01,060 --> 00:02:04,850
my chart expands automatically without me having to do anything.

29
00:02:04,930 --> 00:02:10,699
Now I had inserted the chart before I officially turned this into a table and it didn't matter.

30
00:02:10,720 --> 00:02:18,040
This means that if you currently are using static ranges, you can still just convert them to table

31
00:02:18,440 --> 00:02:20,210
and use your existing chart.

32
00:02:20,230 --> 00:02:26,890
It's going to be smart enough to recognize that the source data is now an official Excel table.

33
00:02:26,890 --> 00:02:33,040
Then we can go about adding data to it and they're going to show up automatically in your chart.