Here are two ways to accomplish the first approach:

http://j-walk.com/ss/excel/tips/tip66.htm
http://bmsltd.ie/DLCount/DLCount.asp...stePicture.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Tom Ogilvy wrote:

assuming form means userform:
You would have to take a snapshot of it and embed the image in an image
control.

Or use the chart component from the office web components - I haven't done
it, but I understand it is possible.