From the course: Excel 2016: Charts in Depth

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Add new data using a table

Add new data using a table

From the course: Excel 2016: Charts in Depth

Start my 1-month free trial

Add new data using a table

- Some charts are created at the beginning of the year, but they're designed with the idea that data's going to be added to the chart, maybe in a monthly basis, maybe on a weekly basis, maybe even on a daily basis. And so when you set up a chart that thought occurs to you sometimes. In the simple example that we're seeing on this sheet called ChartFromTable, we want to update this chart every month. So this chart here, we can see clearly, is based on the data to the left. It's early April let's say. I can highlight both of these cells here, drag the corner of the fill handle downward, and we see the April entry here. Nothing has happened on the chart at all. I'll put in the number here, it's 125, nothing has happened on the chart. If we only update this data once a month, it's not a big deal to simply click the chart, drag that lower right-hand corner, now we've got our data in place. Nothing wrong with that. If we're doing this weekly, maybe a slight irritation factor that we always…

Contents