dynamic name range different values

[lala14b]

Hi, I have a dynamic named range that i use to populate a chart. I need to now create 50 tabs, with the same chart, but different data on each sheet. I've used lookups to pull the data to populate the charts. However, b/c the range is referencing the 1st tab I created, the charts don't update for the new data. Do I really need to create 50 different names for the same range on each sheet, or is there a work around?

Thanks!

 

[Evagrius Ponticus]

I believe this can be solved using the indirect function to reference different sheets . .

http://www.contextures.com/xlFunctions05.html

 

[lala14b]

Thanks so much for the response. When I try to use the indirect in the source data, it gives me an invalid error. Is there a specific way to code this in the source data for a chart?