Adding new data to a chart using a table

- On this worksheet called ChartFromTable,…we're seeing a column chart based on the information…in cells A1 through C6.…Now if I want to add June here,…I can simply highlight cells A5 and A6.…Drag from the corner,…and I've got June for the chart.…But the chart, of course, isn't reacting to that.…And if I put in values here, the chart will not react.…We can certainly make an adjustment.…I can click the chart.…And simply drag the fill handle…here in the lower right-hand corner on C6.…Drag that down.…

And then it makes room for that data.…But what if we update this every month?…Do we have to do that every month?…It's not that hard.…I mean, we could, of course.…What if we had a chart that updated every week?…Or how about one that updated every day, we added data?…This can get a little tedious.…When a chart is based on data,…if you add adjacent data to the bottom of the information…or on the right-hand side,…nothing happens unless that source data has been…formatted as a table.…A table is a relatively new feature.…

Not everybody is familiar with it.…