View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default displaying results like a dashboard counter

Hi Herman,

See Jon Peltier's Speedometer page at:

http://peltiertech.com/Excel/Charts/SpeedometerXP.html


---
Regards,
Norman



wrote in message
oups.com...
Hello,
I built some VBA programmed simulation models with a number of charts.
What I would like to do now is to display some of the results like a
rev counter or a speedometer in a car, instead of a msgbox or yet
another chart.
So if result x may vary between -500% and +500%, it would be nice to
have something like a 180° meter ranging from -500 to +500 with an
arrow indicating de actual result.
Could anyone help me on this one or is my imagination too wild?
Thank you very much for any suggestions.
Herman