If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Gauges for Depicting Business Performance Indicators...
This is my first time looking at this newsgroup, so the answer to my
question may well been discussed previously. For the purposes of presenting business performance indicators, I would like to create a series of gauge symbols (much like the round fuel gauges or speedometers that used to be in cars before the digital dashboard) with an arrow indicating the value of each specific business indicator. The rear face of the gauge would probably have three defined bands, coloured red, yellow and green. As such, if I were tracking six business indicators, I would see six of these gauge symbols. In the first gauge, I might see the arrow at some defined deflection halfway into say the green band. This would tell me at a glance that this performance indicator is in the acceptable range. I've done a search of the Internet using various key words trying to find low cost Excel add-ons that would provide the desired functionality to no avail. Can any of the readers of this newsgroup assist? Thanks in advance to all respondents. -- Gary Rains, P.Eng. Director of Network Planning London Hydro Inc. 111 Horton Street P.O. Box 2700 London, Ontario CANADA N6A 4H6 Telephone: 519.661.5800 Ext 4870 Facsimile: 519.661.5275 E-mail: |
#2
|
|||
|
|||
Gauges for Depicting Business Performance Indicators...
Hi Gary,
Take a look at Jon's example of speedo chart. (http://peltiertech.com/Excel/Charts/SpeedometerXP.html) Gary Rains wrote: This is my first time looking at this newsgroup, so the answer to my question may well been discussed previously. For the purposes of presenting business performance indicators, I would like to create a series of gauge symbols (much like the round fuel gauges or speedometers that used to be in cars before the digital dashboard) with an arrow indicating the value of each specific business indicator. The rear face of the gauge would probably have three defined bands, coloured red, yellow and green. As such, if I were tracking six business indicators, I would see six of these gauge symbols. In the first gauge, I might see the arrow at some defined deflection halfway into say the green band. This would tell me at a glance that this performance indicator is in the acceptable range. I've done a search of the Internet using various key words trying to find low cost Excel add-ons that would provide the desired functionality to no avail. Can any of the readers of this newsgroup assist? Thanks in advance to all respondents. -- Gary Rains, P.Eng. Director of Network Planning London Hydro Inc. 111 Horton Street P.O. Box 2700 London, Ontario CANADA N6A 4H6 Telephone: 519.661.5800 Ext 4870 Facsimile: 519.661.5275 E-mail: -- Cheers Andy http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|