Range names referring to other range names

[Jo Anna]

How do I create a range name that points to another range name, and then edit the data source for the pie chart to the new range name?

 

[Debra Dalgleish]

Jon Peltier has examples of dynamic charts in which a range is defined,
and another range is defined as offset from the first range:

http://www.peltiertech.com/Excel/Charts/DynamicColumnChart1.html