Filling in Data

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

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.
 
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.
 
Back
Top