Charting multiple worksheets

[brulet]

Is there a way to set the source data source from multiple worksheets?

IE
<code>
With chtChart
.ChartType = xlXYScatter
'Set data source range.
.SetSourceData source:=frequencyRange(1)

</code>

 

[pgc01]

Hi

I usually add 1 series at a time (using the .NewSeries() method of the SeriesCollection object). Each new series can have source data from whatever worksheet you want.