A chart that allows for new data to be entered

  • Thread starter Thread starter wjsubs
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help: Chart & data 1
Hiding 0 value data labels in chart 8
Using =Offset in Charts 1
Referencing Chart Data? 1
Why do charts disappear? 2
A chart that allows for new data to be entered 1
Access Combination Chart Types Access 2010 0
Charts that are Off-Screen Disappear after update 4

Back
Top