Chart Data Range

[jsw469]

In excel 2010 under the chart you have a Chart data range. Is there a way to make that dynamic. I have tried to set a named range in there and will not take it. Basicly the Chart is the Legend entries are on row 2 and the Horizontal is on Column A

TY for any help on this

 

[Andrew Poulsom]

Look here:

http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

Note the comment:

Important: You must use the named range along with worksheet name, otherwise excel wont accept the named range for chart source data.