Let's take a look at creating dynamic chart ranges with Excel tables.
Here I have profit information for the productivity division by month.
This time I'm going to highlight it and insert a line chart.
So from the chart options here I'm going to click on 2D line and select the first option in there.
As a first step I'm going to connect the title to A3 right here. I'm going to click on the title,
immediately go to the formula bar, type in equal and click on cell A3.
What happens when I add next month's data to this?
Let's say we're in October now.
I'm going to go with 12,000.
It doesn't pop up in here. For me to get it added to the chart.
I actually have to expand that chart range.
Now this is where you can work with tables. Because that's going to make that whole process dynamic
without you having to do anything. Let's just press Control+Z to go back.
Now before I add my data to this, I'm going to make one simple tweak. That's to transform this dataset
into an official Excel tables.
I'm going to click anywhere inside the dataset and use the shortcut key Control+T.
Excel wants to know if my table has headers.
Well, it does.
It doesn't have any specific header here but watch what happens if you haven't specified any header.
Excel gives its own standard header to this.
I'm going to change this to month.
The only thing I don't like is the formatting here. I'm going to go to the style options and take away
that format to go back to my own formatting.
Notice this is now an official Excel table.
What happens when I add October data to this?
I see October pop up in the chart.
Let's go with 12,500 and that is automatically added here. And my table expands,
my chart expands automatically without me having to do anything.
Now I had inserted the chart before I officially turned this into a table and it didn't matter.
This means that if you currently are using static ranges, you can still just convert them to table
and use your existing chart.
It's going to be smart enough to recognize that the source data is now an official Excel table.
Then we can go about adding data to it and they're going to show up automatically in your chart.