Changing a dial via VBA

Hi guys,

Can anyone point me in the right direction?

I am looking to build a sheet which has a series of dials which show results
from a customer survey. The dial is a semi-circle and the pointer should move
according to the result achieved.

I was looking to superimpose a pointer of some sort onto a graphic, I am
looking to get some code which will automatically move the pointer based on
the result in a cell. I have tried using lines from the Autoshapes menu but
the base of the line sometimes moves, meaning that this doesn't always work.

All suggestions and ideas gratefully received.

Thanks,
Will Francis

This is probably a good starting point:

http://www.peltiertech.com/Excel/Cha...ts.html#Speedo

--
Regards,
Ron