Charts
- From: "Bob" <someonw@xxxxxx>
- Date: Wed, 26 Mar 2008 11:15:27 -0700
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
.
- Prev by Date: Additional controls
- Next by Date: RE: Runtime Error -2147310770(8002801d): Automation Error.
- Previous by thread: Additional controls
- Next by thread: Read headings from CSV into Form in VBA?
- Index(es):