Take a look at Jon Peltier's Dynamic Chart information

http://www.peltiertech.com/Excel/Cha...html#DynColCht

Is this what you are looking for?

"Kris B" <Kris wrote in message
...
I've built a data sheet to represent monthly result data that is appended
to
each month. In the out-months a formula exists to prevent a DIV/0 error
in
the data sheet. Problem is, the out months graph with a zero value. How
do
I fix without having to update the chart range or formulas that calc the
percentages each month?