One of the most powerful aspects of Excel is the fact that various aspects of spreadsheets can be automated.
Next, we need to test whether our self-updating chart actually works.
Fortunately, this is by far the easiest part of the process.
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.
Lay out your information and make sure that each column has a header.
For my example project, I’m creating a chart that tracks sales of each Harry Potter novel at a bookshop.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.You may see a dialog warning you that the table inserted rows into the worksheet — this is absolutely fine.Your chart should have already updated to include the new entry on its X-axis.Now is a good time to make any formatting changes or visual tweaks.