View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
GS80 GS80 is offline
external usenet poster
 
Posts: 26
Default 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