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! |
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 |