Multi Area data ranges as Chart source
 

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

Multi Area data ranges as Chart source
 

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/ChartsH...kChartVBA.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"GS80" wrote in message
...
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

Multi Area data ranges as Chart source
 

Thanks Jon,

This provided exactly what i was looking for.


"Jon Peltier" wrote:

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/ChartsH...kChartVBA.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"GS80" wrote in message
...
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