Excel charts not updating
One of the most powerful aspects of 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, or something more complex, like diving into Visual Basic.
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.
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 Excel charts.
Assuming that’s correct, you’re safe to start adding new data to the table.
For my example project, I’m creating a chart that tracks sales of each Harry Potter novel at a bookshop.
The kind of chart that we’re making works best if you can extend new entries into new rows below.
In my example, as new sales data is recorded, you would add it to the spreadsheet starting in row 11.
The difficulty in handling data and charting is that you constantly have to go back to the chart and update it for new data. I’m going to show you three easy steps to creating charts in Excel that self-update.
All you’ll have to do is add data to the spreadsheet, and the chart will automatically graph it.