Hello cfknight07,

I think the best way to do what you want to track historical data is to track your data like you are doing from cells b19 and down. then you can have your chart area in B10:b14 look up the last value for that list.

You can look up and chart your data using the offset formula:

Here is a tutorial:
How-to Make a Dynamic Chart Using Offset Formula tutorial: http://www.exceldashboardtemplates.com/?p=688

Let me know if this helps.

Steve=True