Hi All,

In excel sheet i have a chart and table for which I am setting data range property at design time.based on the data i want to set it at run time.

select in chart menu---> Source data --> Data range property we are setting at design time. How to set this property at runtime. Please refer the attachment.

could you please help me.

Thanks & Regards in advance,
Areddy

Hi, Areddy,

Update charts automatically when you enter new data (http://www.j-walk.com/ss/excel/usertips/tip053.htm) comes to my mind almost immediately.

Ciao,
Holger