Thanks Kevin for the update.
But my problem is bit different, let me explain:
1. I take the data from an extenal DB to excel on daily basis
2. The volume of data changes every day (may be more or less than the
previous day)
3. To explain you with an example: I have a column A of data to 200 rows. So
my chart's sourc data =Report!$A$2:$A$200 as on yesterday.
4. If I replace it with today's data ColumnA has 250 rows. So my source data
should chang to Report!$A$2:$A$250.
5. I want to have a button with MACRO which will refresh this source data.

For the sake of continuity, please reply in the original thread

--
Don Guillett
SalesAid Software

"Joe" wrote in message
...
Thanks Kevin for the update.
But my problem is bit different, let me explain:
1. I take the data from an extenal DB to excel on daily basis
2. The volume of data changes every day (may be more or less than the
previous day)
3. To explain you with an example: I have a column A of data to 200 rows.
So
my chart's sourc data =Report!$A$2:$A$200 as on yesterday.
4. If I replace it with today's data ColumnA has 250 rows. So my source
data
should chang to Report!$A$2:$A$250.
5. I want to have a button with MACRO which will refresh this source data.

You should be able to find some info on how to make a dynamic chart here

http://peltiertech.com/Excel/Charts/Dynamics.html

"Joe" wrote:

Thanks Kevin for the update.
But my problem is bit different, let me explain:
1. I take the data from an extenal DB to excel on daily basis
2. The volume of data changes every day (may be more or less than the
previous day)
3. To explain you with an example: I have a column A of data to 200 rows. So
my chart's sourc data =Report!$A$2:$A$200 as on yesterday.
4. If I replace it with today's data ColumnA has 250 rows. So my source data
should chang to Report!$A$2:$A$250.
5. I want to have a button with MACRO which will refresh this source data.