Thanks for the reference to the ExcelUser web site that has the business
dashboards. Those are pretty spiffy, so I bookmarked the site. May come
in handy some day.

In the code, just change the object from Sheet1 to the code name for the
worksheet that has all of your charts, for starters. To make it run
faster, normally you would check to see what the Target argument is and
just update that shape, since that is probably the only cell that
changed. You might want to put the code to update the shape in a
separate subroutine.
--
Regards,
Bill Renaud