Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Keep Linked Data after Deleting Report
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Keep Linked Data after Deleting Report
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "K10" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
Selecting Data for report | Excel Worksheet Functions |