Dynamic Chart Object
 

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

Dynamic Chart Object
 

hi,

try

http://www.j-walk.com/ss/excel/usertips/tip053.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Dimri" escreveu:

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