Now is a good time to make any formatting changes or visual tweaks.

Once that’s done, we can test out adding new data to the chart.

By putting in a little effort up-front, you can save plenty of time later on.

updating sheet list in excel-84

Assuming that’s correct, you’re safe to start adding new data to the table.

Above, you can see that I added a sales count of 10 for each book to prompt the chart to update.

Date formatting can be a little tricky, so I’ll drag the bottom right corner of the cell down to populate the cell automatically.

Of course, I could do this manually — I’d just have to lay out my date in the same format as preceding rows.

However, creating complex charts in Excel can be intimidating, so it’s easy to end up settling for simple charts which require a lot of work to maintain.

Charts help shorten the decision-making process, as we can immediately see our results and where we need to make changes.To create a self-updating chart, we first need to set up a spreadsheet that can supply the data we require.The formatting of this document is important because we need to be able to add more data on an ongoing basis.The end goal here is to create a table that feeds data to a chart.Linking these two elements together allows the chart to check for newly added data in the table.You won’t have to depend on others to manipulate or mess up the chart, and you won’t have to do all that extra work either.