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 B@discussions.microsoft.com> wrote in message
news:1FC0C63B-61DD-4FC8-A907-D633DE626C6F@microsoft.com...
> 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?