I'll link to Jon Peltier's chart example for your review:

http://www.peltiertech.com/Excel/Zips/ControlChart.zip

On the data entry screen, it indicates to press F9 to refresh the data, but
I can't figure out what macros are run when F9 is pressed. How do I know?

Thanks in advance,
Barb Reinhardt