Excel VB - Adding Rows To A Chart

  • Thread starter Thread starter kiza
  • Start date Start date
K

kiza

I have produced a table, Data, which automatically generates a char
using Macro's and VB. However, I am trying to add more rows to increas
the size of the chart but unfortunatly, I cannot get the chart range
to increase automatically. Something that I would like to do.

I have attached the file to hopefully help. By clicking onto the Macro
Update, I would like to update the chart even if and when new rows ar
added to the table in Data.

I think that the problem lies in Name Ranges and I have added '*' t
where in the macro I think that the problem is.

Is there anyone who can help me on this as any help would b
appreciated.

Regards,
Kieron Whit
 
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

Expand Chart Source with New Row(s) 1
Dynamic expanding chart 5
Update Chart Source Range When Adding New Row 1
How do I set up a chart that auto updates as new info is added? 1
Can't drag new data to chart in 2007. 1
auto update of a chart 1
reassignning datarange in a macro 2
Need Macro to autofill formula to last row with data 4

Back
Top