This is an extremly basic question but I have spent too much time trying to
figure it out.

I would like to chart a simple X/Y graph. However when I select a chart type
of XlChartType.xlLine it uses the first column in the array as a Y value
array. I would like to have the first column in the array to be the X values
and each subsequent column in the range to be Y1, Y2, etc. If I specify the
first column to be a date then it does just what I want. But if I specify the
first column to be say an integer or double then Excel seems to think that
this is one of the Y values. I just want a plot with the X values taken from
the first column and the Y values taken from the subsequent columns, with a
legend for each of the Y column values and the Y values connected with a
line. Like I said just like it does when the first column is a date.

Thank you.

Kevin