| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Function to Create Array of Size n with values x Through
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet Function to Create Array of Size n with values xThrough
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 On Dec 6, 9:58 am, Dial222 wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Non-Array Function result in non-accurate values | Excel Discussion (Misc queries) | |||
| Non-Array Function result in non-accurate values | Excel Worksheet Functions | |||
| Array Pasted from One Worksheet Converts Null Values to Zeros | Excel Discussion (Misc queries) | |||
| Create a Chart with Values from Array AND NOT from Ranges | Charts and Charting in Excel | |||
Linear Mode
