Assuming this would work manually, try:


With .Chart
..ChartType = xl3DColumnClustered
..SetSourceData Source:=myrange _
, PlotBy:=xlRows

--
Regards,
Tom Ogilvy


"Chip" wrote in message
oups.com...
I am trying to set up a macro which will draw a graph based on a range
where there are non-connected ranges (i.e. A1:F10, and H1:H10). I have
gotten unions to select the given ranges as follows

Dim myrange as range
Set myrange = Union(baserng, subrng1, subrng2)


Then if I do myrange.Select I get the range I would want selected. Now
when I try to put that into my graphing macro I can't get it to work:

With .Chart
.ChartType = xl3DColumnClustered
.SetSourceData Source:=Sheets(tempsheet).Range(myrange) _
, PlotBy:=xlRows

How do I phrase that .Setsourcedata line so this will work? Thanks in
advance.