I have an external add-in to Excel that prints data every day, which increased the data range by 1 cell per day.
I have charts running off this data, but the frustrating thing is, every single day I have to drag down the source data range so that the chart includes the new information. I have attached an Excel file to help explain this. Does anyone know of a way that I can somehow make the chart automatically refresh to include the new data/rows.
Thanks so much, this drives me crazy.
excel help.xlsx
Bookmarks