Multi Area data ranges as Chart source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GS80 - 28 Jan 2008 12:26 GMT

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

Reply to this Message

Jon Peltier - 28 Jan 2008 15:52 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

> Hi,
>
[quoted text clipped - 11 lines]
>
> G

Reply to this Message

GS80 - 30 Jan 2008 09:54 GMT

Thanks Jon,

This provided exactly what i was looking for.

> Is the data for each series contiguous? If so, dispense with the
> SetSourceData statement, and add each series individually, defining the X
[quoted text clipped - 24 lines]
> >
> > G

Reply to this Message