Updating i 9 documents
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.
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 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.
To create a table, select all the data you want to turn into a chart.
Then head to the Insert tab and select Table — alternatively, you can use the shortcut CTRL T.
Rather than just making your data look neat and tidy, they help you group information together.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.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.
Search for updating i 9 documents:
Lay out your information and make sure that each column has a header.