Feb 04 2021 10:40 AM
I have an excel work sheet configured as a table on which I have created two graphs over-layed on the work sheet. When I first created them, I though they update dynamically as I inserted new rows, but now they no longer do that. I must create new ones each time I need to update them. Any solution?
Feb 04 2021 11:23 AM
If you insert new rows in between existing rows of the source range of a chart, they will be included in the source range. But if you insert a new row below the source range, it won't.
A workaround is to turn the source range into a table. When you add rows to the table, they should be included.
Feb 04 2021 01:27 PM
The spread sheet is formatted as a table, and I am inserting at the top to keep the latest entries first without needing to keep sorting. Still, I have this issue with the two graphs overlayed on my spreadsheet table, which will not update with new rows. They did initially, but no longer. The range on the supporting formulas start with the top data row, which is always row two. The range of the graphs is rows 1-35, which is a subset of the total rows.
Feb 04 2021 02:04 PM
The new graphs seem to be updating now. I'll see how long it lasts.