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
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