I want to create a simple XY chart in VB, but I need to have control over
where the data to be charted comes from. Given I want to Chart the range
from Cells(StartRow,StartCol) to Cells(EndRow, EndCol). I can select the
right range to chart, but when it goes to chart it, it creates the chart as 2
series rather than the X and Y for a single series. I follow the recorded
macro format just replacing where the range is inputted with my settings, but
no matter how I set it up, it doesn't seem to work. Ideally, I could set
Xvalues and YValues separately so they don't have to be in columns next to
each other, but I can work around that if need be.

How do I do the SetSourceData Source:=??
Thanks.