Create chart using VBA

[hanif]

Hello,

I have bunch of data in sheet 1 and would like to create a chart (something like scatter lines with XY) of for example col A against col B in different sheet (for example sheet 2). I also want to programme it like if I add more data to sheet 1 the chart will update as well. could you please hekp me with this?

Thanks

[Richard Buttrey]

Hi,

Just create a dynamic range name and use the name in your chart definition.

See this MS support article
http://support.microsoft.com/kb/183446

[Richard Buttrey]

Thanks for the rep and glad to have helped.