Hi Tushar,

However, AFAIK, there is no way to
use a range that contains multiple columns *and* multiple rows in a
chart. It has to be as single column (or row).

Quite right, I had not thought of that. I mostly use dynamic ranges with
multiple rows and columns in Pivot Tables and Pivot Charts, where they are
very useful.

If you add a new column to the data, you just need to refresh the pivot
chart to see a new field in the field list.

Ed Ferrero