Connecting dots in Excel

To fill in gaps in your data, just replace the empty cells with the following formula:

=NA()

And surprise, dots will be connected. No need for interpolation. This is particularly useful for making yield curves in Excel. Source of photo here.