Changing the size of source data for a chart

[AndrewFrame]

I am trying to change the size of the source data for a chart in Excel by one column at a time ussing a command button. E.g i want to change Range("B1:E1, B10:E10&quot to Range("B1:F1, B10:F10&quot by clicking the button and then to Range("B1:G1, B10:G10&quot by clicking the button again. I am unable to get discontinuous ranges whilst using ActiveCell etc.

can anybody please help

thanks

Andrew

 

[SkipVought]

Hi,
Why not use Series tab in the Chart Wizard and add each of the series you want in cols f & g??? Skip,
metzgsk@voughtaircraft.com