Hi, sorry to hear about your dog.

Anyway, I'm just speculating here but couldn't you just have your
chart refencing the cells that are changing so that your chart
would be constantly updating and when you want a printout
just highlight the chart and click on your print button which
should effectively take a snapshot of the chart.

Just a thought
Martin