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.