I was able to use the Dynamic Names feature to accomplish what I need to do, but since I have multiple charts, I'm trying to avoid having to create a separate Dynamic Name that corresponds to each chart.

I'd like to be able to use the following statement in the Series Values section of the data for my chart, but it tells me the formula contains an error:

=Sheet1!$B$11:OFFSET(Sheet1!$B$11,0,Sheet1!$B$13)

Is there a chance I'm just using the wrong syntax or am I not allowed to use OFFSET to define the end range of the Series value?
Thank you.