I create several monthly reports in which we provide table driven charts. While it is one of the greatest features of Excel to have the dynamic cell addressing and it makes building charts that are cumulative very easy, I have the need to break the linkage from the table to the chart so the data remains static, as a monthly snapshot for a cumulative annual report.
The relative cell addressing feature seems to never turn off and the only manner in which I've found in Excel to avoid this is to take a screenshot of the table /chart thus making it a picture (jpg, gif, etc.) and although that has given me what I need. I would also like to be able to modify the table and chart after I've broken the link connection. Some are on the same worksheet, some are moved to a new worksheet but all are within the same workbook.

I hope someone has knowledge of how I can accomplish this task.

Thanks a bunch!
GlennT