Dynamic Chart Object

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Source for excel graph 1
Dynamic chart -easy question that has me stuck 5
Dynamic Axis Titles 1
A formula in this worksheet contains one or more invalid reference 1
Dynamic Range Names / Charting 1
Dynamic Chart Help 3
Dynamic expanding chart 5
Dynamic Chart Update Issue 7

Back
Top