- [Instructor] In the last video,
I showed you how to take a dataset
and to create a chart from it.
But what happens when you need to update that dataset?
I'm going to add some more data to this.
But watch as this chart does not update automatically.
In order to put the new data on the chart,
you need to select the chart, click Chart Design,
choose Select Data,
and from here you can click and drag
to select your new dataset.
I'll click OK.
And now, my Q4 new data has been added.
I'm going to undo all of that
and show you a much easier way that you can do this,
and it's by using something called dynamic charts.
In order to use a dynamic chart,
your data first needs to be in an Excel table.
Now, this is a special type of formatting
that's unique to Excel.
To create an Excel table, click and drag your data.
And from here, you could either choose Format as Table
and choose a way to display your data,
or change to the Insert ribbon tab and click Table.
You can verify that all your data is selected.
And in this case, my table does have headers,
Consumer, Corporate, and Commercial.
So, I'll click okay.
And here's my Excel table.
Now you'll notice the first thing
that happens when you convert your data into an Excel table
is that filter buttons appear automatically.
You can also see
that it's changed the color slightly of my data.
Now you have control over all of this.
I'll click and highlight all of the data
and change to the Table Design tab.
Over here on the right, you can change how it looks.
For example, you can turn the Filter button off.
If you don't like the banded rows, you can uncheck that.
And you can also change the table style.
That is how it's going to look.
But more importantly,
is what you can accomplish with a table.
All the way on the bottom right hand side,
notice this little blue icon.
This means that my data is in a table.
When I'm at the end of this data
and I hit the Tab key to move to a new row,
my dataset is going to expand automatically.
I don't have to do anything.
Now watch what happens to my chart.
I'll put in Q4,
and instantly it's starting to update itself on the fly
without me having to even worry about it.
It's added the rest of my data points
and updated automatically.
So this is fantastic for charts,
but it's also great for formulas.
When you're working on a formula,
if you put your data into a table first,
if you continue to add more rows,
those rows will also be included in that formula.
So there's many reasons to use tables,
and it's not just for charts.
But it's excellent if you think
you're going to be constantly adding to this dataset.
You might want to think ahead and put your data
into an Excel table ahead of time.
And remember, we did that by selecting all of our data,
changing to the Insert tab and clicking Table.
You'll notice it's grayed out now.
That's because our data already is in a table.
But you can also do this on the Home ribbon tab
by clicking Format as Table and choosing a style.