Hello Experts,

1. I import data from an external DB to excel in a specified format.
2. I generate few charts/graphs in excel using the data imported into excel.
3. How can I make the source data of the chart dynamic as the imported data
changing.
ex:Source data=Sheet1!$A$1:$A$150
I want to change this $A$150 (last value in the column) dynamically using
macro.

Appreciate your help..