Copy and Paste Graph from One File to Another

[cghoga]

Greetings,

I have been given a report that contains 2 report tabs and a 3rd tab containing several graphs.

The first 2 tabs of the file are generated weekly out of a Business Objects (BO) scheduled export to Excel.

The 3rd tab is something upper managament slammed into the Excel file and they want it refreshed weekly each time the report is generated out of BO.

My question is, is there a way to copy and paste the 3rd tab from the previous week's file to the current report and the data source of the graphs drop the connection to the previous file and be connected to the current file without having to manually go in and update each graph.

My sincerest apologies if this has already been addressed in another thread.

Thanks for your help,

cgh

 

[SkipVought]

Hi,

You keep the Chart and update the source data for the chart.

I like using DYNAMIC Named Ranges. That way, when you update the source data, the Named Range 'adjusts' and the Names in the Chart, that reference the Source, automatically use the Name's adjusted range.

faq68-1331


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}