Percentage Gauge Needle

**Sal1tech** · 04-04-2014, 05:43 AM

Is there a simple way of having a percentage display a number from a single cell.

All I need is the grand total percentage, which has already bee calculated and formulated to show as a slick gauge.

For example the number 91% displays in a single cell. How do I get a gauge to display this number.

**AndyLitch** · 04-04-2014, 10:03 AM

If you're thinking of a traditional style dial gauge there is no simple way although it it is do-able with a bit of Trig and VBA.

You could use a progress bar style display using a built in scroll bar ....

**DBY** · 04-04-2014, 10:39 AM

Hello

If it's a speedometer type chart you're looking for their are plenty of examples on YouTube, for example:

http://www.youtube.com/watch?v=zean4MztvjM

As Andy says, not sure if you would call it simple but by way of an example see the attached file working with percentages.

Hope this helps.
DBY