How to add data Range property at runtime to excel sheet

[areddy]

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

 

[HaHoBe]

Hi, Areddy,

Update charts automatically when you enter new data comes to my mind almost immediately.

Ciao,
Holger