Filling in Data
 

I have several points where I need data. I only have the start and the end
values and I want to fill in each of the points between the two. How is that
accomplished.

Example. Point 1 = 50, Point 10 = 600. I need Points 2-9.

Filling in Data
 

550/9 = the increment to add moving from point 2 to point 9

Jamie wrote:

I have several points where I need data. I only have the start and the end
values and I want to fill in each of the points between the two. How is that
accomplished.

Example. Point 1 = 50, Point 10 = 600. I need Points 2-9.

Filling in Data
 

Hi,

Try this and enter data into cells

A1=50
a10=600

Select A1 to A10 then

Edit|Fill|Series
Ensure 'Columns' and 'Linear' are selected and Excel will work out the step
for a linear growth from 10 to 600.
OK
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Jamie" wrote:

I have several points where I need data. I only have the start and the end
values and I want to fill in each of the points between the two. How is that
accomplished.

Example. Point 1 = 50, Point 10 = 600. I need Points 2-9.