A chart that allows for new data to be entered

W

wjsubs

I have a set of data that I need to use in a chart. I also need for th
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 ge
a chance.

Thanks,
Wil
 
T

Tom Ogilvy

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
 
Top