Creating a monthly payment chart

[Davidns]

I have a spreadsheet that contains the following information:

monthly payment, # of months of the payment to be made.

From this data, I would like to figure out an easy way to create a table showing month 1, month 2, etc in column 1, and the monthly payment in column 2.

Is there an easy way to do this? I have about 500 contracts to analyze, so would very much prefer not to have to manually create the table, but to generate it via the summary information I have.

Thanks!
David

 

[jevi]

http://peltiertech.com/Excel/Charts/...tml#DynoLast12

Check this link as it might help you. I used it do plot data automatically for my charts that i have to do each month.