Graphing with NAMED RANGES - VBA II

[Terry_Orange]

Please ignore the last post !

Having established how to construct a graph with a named range, can anyone give me advice on how to use more than one range in a graph.

ie.

ActiveChart.SetSourceData Source:=myRange1, PlotBy:=xlRows

WORKS.

but if I want more than one range in my source

ActiveChart.SetSourceData Source:=(myRange1,myRange2,myRange3), PlotBy:=xlRows

DOESN'T WORK.

Anyone any ideas ???
Nick.
This message was edited by Terry_Orange on 2002-10-03 07:20

 

[Damon Ostrander]

Hi Nick,

I believe you should be able to use square brackets:

ActiveChart.SetSourceData Source:=[myRange1,myRange2,myRange3], PlotBy:=xlRows

so long as the three ranges are all on the active worksheet. The square brackets are just a shorthand alternative to

Range("myRange1,myRange2,myRange3")

to return a range object that includes all three ranges.

Damon

 

[Andrew Poulsom]

Or you can create a Range object using the Union method and pass that variable as the Source.