The following will show you how to make interactive tables and graphs in Excel. This will be another application for relative and absolute cell references.
Excel as a Graphing Calculator (Google Doc)