Problem with dynamic graphs over several sheets

[davidJIBS]

Hey,

In the attached excel file there are two examples, the first example is the one that im having problems with and the second example is how I usually create a dynamic graph. The table in example one will expand when I enter in new data in "sheet 1" and "sheet 2" but I want the graph to change as that happens. I can make this happen in example 2 but in example 2 i enter in the new data directly into the table, the point is that I want the data to come from the new data in the other sheets.

Thanks in advance! :)

[Pauleyb]

You will likely need to create some named variables. Do a google search for "dynamic graph excel" and you will find plenty of tutorials.

Pauley