Forum Discussion
Overlayed graphs do not update as new rows are inserted in a table
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, ...
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.