How to Construct Yield Curves in Excel 2007. Yield curves plot bond interest rates over different contract lengths. Contract lengths vary from two months to twenty years.