add a textbox to the chart. link the chart to a cell. The cell can contain the NOW formula.
Recalculate sheet before exporting.

http://www.andypope.info/tips/tip001.htm