I would go with a lookup. Your chart is based on a fixed range of cells. That range of cells is populated using INDEX function.

Check this previous thread
http://www.excelforum.com/excel-char...l-clicked.html