Line Graph variable horizontal axis

I have created a loan amortization schedule which changes based on set inputs, one being number of years. I have then created a line graph to show the repayment of the loans over the time period. I would like my line graph horitontal axis to change according to how many date fields are showing in my whole range of data. So a 20 year loan or a 40 year loan the axis updates automatically. Can anyone help with this?

My source data for the line graph is my amorisation schedule which computes data vertically based on the period, so although ive put formulaes in based on the maximum 50year loan, if its a 20 year loan the rows are blank after that period. Very hard to explain in words but i will upload my spreadsheet and hope someone can help me.

thanks, Kat82

Hi,

Please find attached second graph, i have used name manger for dynamic range and same range used for graph. Do the same for other graph.

check last value from second table is less than zero hence that is not picking in graph.

Regards,
Suhas

Thanks Pangam_s, i couldnt copy your solution to the other graphs unfortunatley though, a little beyond my expertise i think. The graph was showing the loan balance too, not the interest payments so i was unable to use, and the date range on all 3 graphs is the dates applicable on the first graph, this way the 3 graphs can be compared. thanks heaps for you help though. Cheers, Kat82

Go in name manager and check offset function and create same type of range for other graphs and link that is to your graph. if any wrong range pulling in graph then change the range.

Regards,
Suhas