set the source to one of the ranges, then add a new series from the other.

--
Regards,
Tom Ogilvy


"David" wrote:

How do I use SetSourceData to get information from two different worksheets?

I have two matching tables on two worksheets and I would like to be able to
chart similar data from the two sheets. eg.

Chart5.SetSourceData Source:=Sheets("ResultsIn").Range("D3:D15,E3:E15") , And _
Sheets("ResultsOut").Range("D3:D15,E3:E15"), _
PlotBy:=xlColumns

David