I apologize for probably asking a question which has already been answered here.

I have a data set which I "update" once or twice a week. Each update adds several new rows to the data sets.

Currently I am manually editing my chart's data series to include the new rows.

I have not named any data ranges. I simply refer to cell addresses in the charts.

How do I use ranges (and any formulas such as offset or indirect) to accomplish the charting of added data?

If helpful I can attach the spreadsheet.

Thanks!