Multi Area data ranges as Chart source

[GS80]

Hi,

Hopefully someone can shed some light on how best to do this. I'm working
with the Excel object model and want to specify a data range which consists
of non contiguous columns in the dataset. I cannot seem to find a way to do
this and then set the data range to the data source of the chart.

I've looked into Range Areas and cannot quite see if these will resolve my
problem or not. Any help is greatly appreciated on this subject.

Many thanks in advance,

G

 

[Jon Peltier]

Is the data for each series contiguous? If so, dispense with the
SetSourceData statement, and add each series individually, defining the X
and Y value range for each as you go. This tutorial should get you started:

http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html

- Jon

 

[GS80]

Thanks Jon,

This provided exactly what i was looking for.