Solved

Drashboard Gauges speedometer

Posted on 2011-09-26
3
408 Views
Last Modified: 2012-05-12
I need a ride drashboard to excel in the financial sector of the company I work, I am trying to develop in Excel 2007 I would like a help on how to style speedometer gauges I have an image in PNG would like to use as a speedometer but the calculation and how to position the pointer in the correct position is that I do not know how. I need a step by step.
0
Comment
Question by:eduardo12fox
3 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 250 total points
ID: 36598819
0
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst
Ingeborg Hawighorst earned 250 total points
ID: 36602225
Hello,

speed gauges are a very inefficient way of showing data. They take up a lot of space to convey just one single item of data.

You should have a look at bullet charts instead, which can show many aspects of data in a very small space.

Some background here
http://peltiertech.com/WordPress/not-gauges-again/
http://www.performance-ideas.com/2011/07/25/cognos-gauge-chart/
http://everythingxcelsius.com/xcelsius-2008/the-slow-death-of-a-gauge/2543

Step by step for creating bullet graphs
http://www.exceluser.com/explore/bullet.htm

cheers, teylyn
0
 

Author Closing Comment

by:eduardo12fox
ID: 37039182
OK! Very Well
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question