I was thinking Pivot Table, three of them in fact, each based on the
same data. Each PT uses a different Value field in its Page area. Each
PT has a Pivot Chart based on it, or a regular chart that's driven by
defined names, as Don suggests. Change the data sheet, and everything
else updates.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Don Guillett wrote:

insertnamedefine
Use a defined name for your chart series such as
netsales
=offset($A$2,0,0,counta($a:$a),1)
now your source would be =sheet1!netsales