Hey everyone, I'm having an issue with a chart in Excel 2007. I have a column of PVs of bonds. Now due the type of bond I'm using (Premium, Discount, Par) these PV values either decrease, increase, or stay the same throughout.

I'm not sure how relevant the above information is but here is my question. When my Present Values stay the same on the whole problem my chart goes haywire. My chart tracks PV over time, but instead of showing a straight line, it goes all over the place...

Can anyone help?

I'm new to the site so if its possible for me to upload my spreadsheet please let me know. Thanks!