inputting (x) triggers input of 1 through (x)
 

I created a spreadsheet that displays results dependent upon the year. I
would now like to create a graph that displays results for all years 1
through x, where x is a year chosen between Year 1 and Year 30. The nature
of the formulas require that each year between 1 and x be run through
separately. For example, to plot an accurate graph that tracks results
through Year 4, I need to run year 1 through the formulas, then 2, then 3,
then 4, deriving results for each.

Can you suggest a function or program that will help me do this?

Thanks!