Charting from a different range location

[tayseer.abdelhalim]

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

 

[broro183]

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 here:
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/communitie...462-3776-4f93-80b7-d3122b786559&lang=en&cr=US




Rob

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