Can my graph automatically update as new data is added to the cell range?

[Lanny94]

Hello! I have created a tracker that I update weekly with data for that week. I currently have a line graph at the top of the sheet that shows the trend of the data that I am tracking. The problem I am having is that every week that I add new data, I need to manually go into the data range for the graph and change it so that it includes the new data. Is there a way that my graph will automatically update and include the new data as it is added? If I change the data range on the graph to include blank cells that will eventually be filled in with data, the graph shrinks and shows blank areas on the far right as if the empty cells in the data range = 0.

Below is a screenshot to help illustrate my sheet.

All help is greatly appreciated! Thank you!

 

[Saba Sabaratnam]

You could turn your data table into Excel table which will automatically your graph when you add new records to the table.

Kind regards

Saba

 

[Lanny94]

Thank you Saba!