Updating a table
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, or something more complex, like diving into Visual Basic.
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 Microsoft Excel that self-update.
All you’ll have to do is add data to the spreadsheet, and the chart will automatically graph it.
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 add more data, simply add another line at the bottom of your existing chart.
Challenge yourself to learn something new in Microsoft Excel, and it will pay off tenfold in the long run.In the Create Table dialog, you can tweak the cells included in the table.Tick the box labeled My table has headers, then press OK.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.To create a table, select all the data you want to turn into a chart.