in reply to Re^2: Excel Chart
in thread Excel Chart

Making the range dynamic is as easy as constructing the appropriate string for the range.