Most use a dynamic range

Insert = Name = Define
Name: List1
RefersTo: =Offset(sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),1)

Set the source of the chart to the name

=Book1.xls!List1

--
Regards,
Tom Ogilvy

"wjsubs " wrote in message
...
I have a set of data that I need to use in a chart. I also need for the
graph to include the new monthly data that I will enter.

I have tried to make the data range cover an extra 50-60 data points,
but when I pull up the chart it is basically blank.

If anyone knows a fix for this problem please let me know when you get
a chance.

Thanks,
Will


---
Message posted from http://www.ExcelForum.com/