Worksheet Function to Create Array of Size n with values x Through

  • Thread starter Thread starter Dial222
  • Start date Start date
D

Dial222

Trying to use combination of Rept function to generate an array of like
values. I then want to use this array to plot a straight line on a chart.

Is there an easier way to do this, is it possible.

Cheers
 
REPT is used for text values - not much use for graphs.

You could put this formula in A1:

=ROW()

and this one in B1:

=A1*C$1 + D$1

where C1 represents the slope that you want (eg set it to 2), and D1
represents the intercept on the Y axis. Then just highlight A1:B1 and
copy down for as many points as you need. Column A then contains your
x values, and column B the y values.

Hope this helps.

Pete
 
Back
Top