Start Insert auto updating date in word

Insert auto updating date in word

To create a self-updating chart, we first need to set up a spreadsheet that can supply the data we require.

You can now use the chart indefinitely, simply by adding more rows to the table.

However, you may have to tweak its size and formatting to present all the data properly, depending on how much you’re planning to add.

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

Challenge yourself to learn something new in Excel, and it will pay off tenfold in the long run.

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 add more data, simply add another line at the bottom of your existing chart.

Since my Date column dictates the values on the X-axis of my chart, I’ll start there.

Next, we need to test whether our self-updating chart actually works.

Fortunately, this is by far the easiest part of the process.

Charts to choose what kind of visualization to use.