Create Excel charts that automatically update data with these three simple steps

Excel charts help shorten the decision-making process, because we can immediately see the results and things to change. However, the difficulty in processing data and charts is that users must constantly return to the chart and update new data. Yes, this problem will be gone when you follow these three simple steps to create an Excel chart that automatically updates data. All you need to do is add data to the spreadsheet and the graph will automatically graph.

1. Set up a spreadsheet

To create an automatic data update chart, you first need to set up a spreadsheet that provides the required data. The format of this document is very important because you will need to add more data to this spreadsheet. Fill in the information and make sure that each column has a title. In this example is a chart that tracks the sales of each Harry Potter novel at a bookstore.

1. MS Excel - Lesson 2: Format spreadsheet data

Create Excel charts that automatically update data with these three simple steps Picture 1

This type of chart is best when expanding new items into the rows below. In this example, when new sales data is recorded, the user will add it to the spreadsheet starting from row 11.

Create Excel charts that automatically update data with these three simple steps Picture 2

2. Create a table

In Office 2016 , the table has been enhanced, instead of just making data look neater, they also help group information together. The ultimate goal here is to create a data table for the chart. Linking these two elements together allows a new data check chart to be added to the table.

To create a table, select all the data you want to turn into a chart. Then go to Insert tab and select Table or use Ctrl + T shortcut.

Create Excel charts that automatically update data with these three simple steps Picture 3

In the Create Table dialog box, edit the cells in the table. Check the My table box that has the headers then click OK .

Create Excel charts that automatically update data with these three simple steps Picture 4

The data added to the table looks like the following:

Create Excel charts that automatically update data with these three simple steps Picture 5

3. Insert the chart and add data

Select the entire table and go to Insert > Charts to select the type of chart you want to use. The type of chart will depend on the type of data you are working on. In this example use a line chart, which helps compare many different columns and works very well with automatic updates.

1. MS Excel - Lesson 6: Four steps to create an Excel chart

Create Excel charts that automatically update data with these three simple steps Picture 6

Now is a good time to make any format or image tweaking. Next we will add more data to the spreadsheet, simply add another line at the end of the existing worksheet.

Create Excel charts that automatically update data with these three simple steps Picture 7

Now you can use the chart indefinitely, simply by adding multiple rows to the table. However, it may be necessary to adjust the size and format to display all the correct data, depending on the additional quantity.

Create Excel charts that automatically update data with these three simple steps Picture 8

I wish you all success!