Calculating data series values to form a 45 degree line

[dviper]

I have been asked to spread a series of values over a set number of months that will form a data series that will produce 45 degree line when graphed. Any ideas on the excel formula to calculate the monthly amounts?

 

[Jon Peltier]

45 degrees depends on the dimensions of the chart and the min and max of the axes.

Do you have to spread values over a range of months, or just draw a line corner to corner?