multiple sheets with charts, but charts allrefer to data in one sheet...how do I make themrefer to d

[mgrowdon]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I have multiple sheets containing lists of data that change with pressure and temperature inputs. I have 28 series that need to be plotted on each graph, and the data for each series changes with each new sheet, though the series and the organization of the series are identical. I would like to make one chart for each worksheet that refers to the data in that worksheet, but as I have 81 separate sets of conditions, I'd rather not recreate the chart from scratch 81 times with 28 series each.

I can copy and paste the chart from sheet to sheet, and/or I can make a copy of the sheet, including a completed chart, however in both of these situations the chart, regardless of being pasted in a new sheet, still refers to the data in the original sheet.

Is there a way to make the copied chart refer to the data in each new sheet into which the chart is placed?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I have multiple sheets containing lists of data that change with pressure and
temperature inputs. I have 28 series that need to be plotted on each graph,
and the data for each series changes with each new sheet, though the series
and the organization of the series are identical. I would like to make one
chart for each worksheet that refers to the data in that worksheet, but as I
have 81 separate sets of conditions, I'd rather not recreate the chart from
scratch 81 times with 28 series each.

I can copy and paste the chart from sheet to sheet, and/or I can make a copy
of the sheet, including a completed chart, however in both of these situations
the chart, regardless of being pasted in a new sheet, still refers to the data
in the original sheet.

Is there a way to make the copied chart refer to the data in each new sheet
into which the chart is placed?

You could name the ranges in the first sheet. Use sheet level, not global
names. Then when the sheet is copied, the names should refer to ranges on
that sheet.