Hi Paul,

Am I correct in my interpretation of your post that the data on each of the
worksheets is the same type of data with the same column headers but with
different values and you want to have just one graph but change the data for
the graph by selecting a different worksheet?

If my interpretation is correct, have you thought about having all the data
on one worksheet and using AutoFilter. You can set up your graph on the
AutoFiltered range and the graph becomes dynamic by displaying the series for
the visible cells on the worksheet after the filters are set. You simply need
a column in the AutoFiltered range that reflects each group of data which
currently is reflected by which sheet the data in on.

If the above is an option and you can't work out how to achieve the end
result then let me know what type of charts (graphs) and I will attempt to
provide some tuition to get you started.

Also what version of Excel are you using?

--
Regards,

OssieMac


"PvZ" wrote:

In my workbook I have multiple sheets.
I have a summary sheet, called: Graphs, consisting of (only) graphs,
build from the data from the various sheets. These graphs do not change.
I would like to determine (via the Graph-sheet), from which worksheet
the data should come from.

For a (particular) graph, the [chart data range] is, e.g.:
='Sheet100'!$F$6:$F$10
The value: "Sheet100" is what I would like to choose/vary;
- preferably by selecting a cell with the name of the sheet I want the
graph(s) made from (e.g. A1=Sheet100; A2=Sheet200 aso.
By seecting Cell A2 (on sheet: Graphs) the graphs will be build using the
data on Sheet200 . . . , or:
- by typing the name of a worksheet in a (fixed) cell
(e.g. typing: Sheet200 in Cell A1)

Note: all the worksheets have the same columns (but may vary in number of
rows, although this could be also made the same).
Hope you understand my question !

Regards,

Paul