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 |
Changing a dial via VBA
This is probably a good starting point:
http://www.peltiertech.com/Excel/Cha...ts.html#Speedo -- Regards, Ron |
All times are GMT +1. The time now is 05:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com