Interactive data entry and updating
One of the most powerful aspects of Microsoft Excel is the fact that various aspects of spreadsheets can be automated.
This might be something as simple as creating a basic self-updating chart, like we’ve seen here.
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.
You don’t need any Visual Basic skills, but you do need to understand the basic fundamentals of Microsoft Excel charts.
To create a table, select all the data you want to turn into an Excel chart.
Then head to the Insert tab and select Table — alternatively, you can use the shortcut CTRL T.
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.
Your chart should have already updated to include the new entry on its X-axis. However, creating complex charts in Microsoft 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.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.