List 1 to n in cells for a given n

[ajaysomasi]

Hi, I have a number in cell A1 which keeps changing.. Whatever that number is, I want excel to list 1 to n automatically as the number keeps changing..

Example, if I have 10 in cell A1, it should list 1 to 10 from C1 to C10.. if I change it to 20, it should list 1 to 20.. change it back to 15, it should list 1 to 15..

can u please help me with a formula or vba code please...

 

[mikerickson]

Put =IF($A$1<=ROW(A1),ROW(A1),"") in C1 and drag downwards.

 

[ajaysomasi]

hi mikerickson, thank you for this..

I have a second question.. now that list keeps changing based on the value in A1, how do I plot these values automatically.. I mean how to capture the changing list (sometimes 1 to 20, sometime 1 to 15 etc) in an automatic manner in a chart ignoring all the other "" cells..

 

[mikerickson]

You're chart is going to be a straight line. Just change the legend on the axes.