Hi Tayseer,

Please keep a specific question in a single original post or if asking the
same question elsewhere please mention that you are cross posting. For some
background to this request have a look at Ken's explanation he
http://www.excelguru.ca/node/7

I'm putting some suggestions as a reply to your original post in the Excel
Charts section which I've seen at:
http://www.microsoft.com/communities...&lang=en&cr=US




Rob

__________________
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


" wrote:

I recorded a macro to draw a chart for a range of data. However, I
would like to generalize the macro, because the range of data can be
in a different location (in the same sheet)...Can someone kindly tell
me the code for doing that...Thx much

Tayseer