Keep Linked Data after Deleting Report

[Guest]

I'm making metrics for my group at work. I have downloaded/sorted each
month's data & placed each month into a different tab on the same worksheet.
On one tab I have created a chart that takes information from each month and
measures it on the chart (using the COUNTIF function). Since this is the
document that my team will be using...we will be deleting months as time goes
on to make more room. However, in order to continue measuring the trend,
we'd like the value for the the months that are outdated and we delete to
remain. When I go to delete the tab with the data in it...the value
disappears in the chart. Is there another way to link the two so that when I
delete the data, I can keep the value in the chart. Thank you!

 

[Jon Peltier]

First, it seems to me that disk space is rather cheap nowadays, not like
when I was young and our computers ran by candlelight. My first suggestion
would be to keep the old sheets, perhaps hide them if necessary.

If the sheets have lots of extra data and you are plotting only a small
fraction of values which are calculated from the larger database, perhaps
you can convert the formulas to values (Copy - Paste Special Values), delete
the original data, and keep only the data required for the chart.

- Jon