Charts



Hi Everyone:

In excel, I would like to plot an array Y versus an array X as a scattered
plot. When looking at the chart methods, I could only see how to plot a
range, and not two arrays. For example I know to plot a range, I have to
use: ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("C10:D17").

Can someone please show me how to plot Y vs. X without writing the data to
the spread*** and then reading the range.

Thanks;

Bob


.