G Guest Feb 28, 2004 #1 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?
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?
D Debra Dalgleish Feb 29, 2004 #2 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
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
