Inserting chart into another workbook

[ranebow]

I have two different workbooks (Detail and Consolidated). In the detail one I have a chart that is created from many sheets within this workbook.

I'd like to pull a chart (that is on a sheet by itself) and put a smaller version of it on the Consolidated sheet.

When the detail one is updated I'd like it to update the consolidated also.

Is this possible? I've done it with sheets, but can't get it to do the chart.

 

[SkipVought]

ranebow,

Hopefully, the DATA in your Detail and Consolidated workbooks is TABULAR: one sheet per table.

Furthermore, I hope that the TABLE STRUCTURE is identical.

If that's the case, you can use each of these workbooks as SOURCE DATABASES for queries, using MS Query via Data/Get External Data/New Database Query -- Excel Files -- YOUR WORKBOOK........

Return the resultset to Excel (could be a THIRD workbook or Detail or Consolidated) and THIS DATA is the Source Data for your chart.

I use this technique often to create interactive charts using dropdowns, and other controls to select new data for the chart to display. Where many people create dozens of charts of similar data, I only create ONE CHART with controls to vary the display. Only if it is required to view multiple charts simultaneously, do I do othwise.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}