Hi all. I am making some charts and need some help with the cells the chart
references as source data.

I am trying to make it so that I can insert and delete rows while having the
chart reference the original cell, rather then automatically updating and
following the cell when I add or remove rows. Basically trying to do the same
thing in the chart as I can do with a formula by using the "indirect" feature.

Is this possible with a chart? Having to go back in and manually change the
references back to the original cells is time consuming each week.