Self updating excel graphs

After you create a chart, you might want to change the way that table rows and columns are plotted in the chart.

Linking these two elements together allows the chart to check for newly added data in the table.

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.

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.

Refresh | Change Data Source Any changes you make to the data set are not automatically picked up by the pivot table.