Hi,

You need to use named ranges with dynamic formula.
Have a look at Jon Peltier's page, which contains information on the
technique and links to other sites.

http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

pokdbz wrote:
I have a chart now with this in the data range:
=PHQChartQuery!$A$2:$C$7

But I would like it to look like this
=PHQChartQuery!$A$2:$C$500

But when I do there there alot of extra points on the graph. I would like
it to only show on the graph only the rows that have data in them and then if
I add data later on it will update the graph. So I don't have to keep
redoing the range everytime data is entered.

Is this possible?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info