depicting a guage with a percentage 0 - 100%

Matt Pinkston
Matt Pinkston used Ask the Experts™
on
What Microsoft tool and how could I create a gauge with an adjustable needle to show 0 - 100%
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
GrahamSkanRetired
Top Expert 2012
Commented:
There isn't one supplied with Office, but you can design one  with a couple of label controls of the same height. One will represent the maximum value. Place another with a different background colour on top of the first with the left-hand edges coincident. Adjust its width to show the current value that you want to show.
Matt PinkstonEnterprise Architect

Author

Commented:
sorry not much of an artist
Here is a possible solution.
It is made with some shapes for the background and the needle, and a pie chart for the values.
A macro rotates the needle.
Gauge-example.xlsm

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial