1
00:00:00,05 --> 00:00:01,09
- [Instructor] In the last video,

2
00:00:01,09 --> 00:00:03,09
I showed you how to take a dataset

3
00:00:03,09 --> 00:00:06,01
and to create a chart from it.

4
00:00:06,01 --> 00:00:09,03
But what happens when you need to update that dataset?

5
00:00:09,03 --> 00:00:13,00
I'm going to add some more data to this.

6
00:00:13,00 --> 00:00:18,00
But watch as this chart does not update automatically.

7
00:00:18,00 --> 00:00:20,01
In order to put the new data on the chart,

8
00:00:20,01 --> 00:00:24,03
you need to select the chart, click Chart Design,

9
00:00:24,03 --> 00:00:27,01
choose Select Data,

10
00:00:27,01 --> 00:00:29,01
and from here you can click and drag

11
00:00:29,01 --> 00:00:32,08
to select your new dataset.

12
00:00:32,08 --> 00:00:34,01
I'll click OK.

13
00:00:34,01 --> 00:00:38,05
And now, my Q4 new data has been added.

14
00:00:38,05 --> 00:00:40,03
I'm going to undo all of that

15
00:00:40,03 --> 00:00:43,08
and show you a much easier way that you can do this,

16
00:00:43,08 --> 00:00:47,01
and it's by using something called dynamic charts.

17
00:00:47,01 --> 00:00:49,03
In order to use a dynamic chart,

18
00:00:49,03 --> 00:00:53,00
your data first needs to be in an Excel table.

19
00:00:53,00 --> 00:00:55,02
Now, this is a special type of formatting

20
00:00:55,02 --> 00:00:57,00
that's unique to Excel.

21
00:00:57,00 --> 00:01:01,04
To create an Excel table, click and drag your data.

22
00:01:01,04 --> 00:01:05,00
And from here, you could either choose Format as Table

23
00:01:05,00 --> 00:01:07,03
and choose a way to display your data,

24
00:01:07,03 --> 00:01:13,01
or change to the Insert ribbon tab and click Table.

25
00:01:13,01 --> 00:01:16,00
You can verify that all your data is selected.

26
00:01:16,00 --> 00:01:18,06
And in this case, my table does have headers,

27
00:01:18,06 --> 00:01:20,05
Consumer, Corporate, and Commercial.

28
00:01:20,05 --> 00:01:24,09
So, I'll click okay.

29
00:01:24,09 --> 00:01:26,03
And here's my Excel table.

30
00:01:26,03 --> 00:01:28,00
Now you'll notice the first thing

31
00:01:28,00 --> 00:01:30,08
that happens when you convert your data into an Excel table

32
00:01:30,08 --> 00:01:34,06
is that filter buttons appear automatically.

33
00:01:34,06 --> 00:01:35,07
You can also see

34
00:01:35,07 --> 00:01:38,09
that it's changed the color slightly of my data.

35
00:01:38,09 --> 00:01:42,01
Now you have control over all of this.

36
00:01:42,01 --> 00:01:44,02
I'll click and highlight all of the data

37
00:01:44,02 --> 00:01:47,02
and change to the Table Design tab.

38
00:01:47,02 --> 00:01:50,00
Over here on the right, you can change how it looks.

39
00:01:50,00 --> 00:01:53,01
For example, you can turn the Filter button off.

40
00:01:53,01 --> 00:01:56,03
If you don't like the banded rows, you can uncheck that.

41
00:01:56,03 --> 00:01:58,08
And you can also change the table style.

42
00:01:58,08 --> 00:02:01,06
That is how it's going to look.

43
00:02:01,06 --> 00:02:03,01
But more importantly,

44
00:02:03,01 --> 00:02:06,03
is what you can accomplish with a table.

45
00:02:06,03 --> 00:02:08,08
All the way on the bottom right hand side,

46
00:02:08,08 --> 00:02:11,06
notice this little blue icon.

47
00:02:11,06 --> 00:02:14,06
This means that my data is in a table.

48
00:02:14,06 --> 00:02:16,04
When I'm at the end of this data

49
00:02:16,04 --> 00:02:19,04
and I hit the Tab key to move to a new row,

50
00:02:19,04 --> 00:02:22,06
my dataset is going to expand automatically.

51
00:02:22,06 --> 00:02:24,05
I don't have to do anything.

52
00:02:24,05 --> 00:02:26,07
Now watch what happens to my chart.

53
00:02:26,07 --> 00:02:27,08
I'll put in Q4,

54
00:02:27,08 --> 00:02:31,04
and instantly it's starting to update itself on the fly

55
00:02:31,04 --> 00:02:39,01
without me having to even worry about it.

56
00:02:39,01 --> 00:02:41,02
It's added the rest of my data points

57
00:02:41,02 --> 00:02:43,05
and updated automatically.

58
00:02:43,05 --> 00:02:45,04
So this is fantastic for charts,

59
00:02:45,04 --> 00:02:48,00
but it's also great for formulas.

60
00:02:48,00 --> 00:02:49,06
When you're working on a formula,

61
00:02:49,06 --> 00:02:52,06
if you put your data into a table first,

62
00:02:52,06 --> 00:02:54,09
if you continue to add more rows,

63
00:02:54,09 --> 00:02:58,05
those rows will also be included in that formula.

64
00:02:58,05 --> 00:03:01,01
So there's many reasons to use tables,

65
00:03:01,01 --> 00:03:03,03
and it's not just for charts.

66
00:03:03,03 --> 00:03:05,01
But it's excellent if you think

67
00:03:05,01 --> 00:03:08,02
you're going to be constantly adding to this dataset.

68
00:03:08,02 --> 00:03:10,09
You might want to think ahead and put your data

69
00:03:10,09 --> 00:03:13,01
into an Excel table ahead of time.

70
00:03:13,01 --> 00:03:17,02
And remember, we did that by selecting all of our data,

71
00:03:17,02 --> 00:03:20,00
changing to the Insert tab and clicking Table.

72
00:03:20,00 --> 00:03:21,06
You'll notice it's grayed out now.

73
00:03:21,06 --> 00:03:24,04
That's because our data already is in a table.

74
00:03:24,04 --> 00:03:27,05
But you can also do this on the Home ribbon tab

75
00:03:27,05 --> 00:03:31,00
by clicking Format as Table and choosing a style.