Solved

Drashboard Gauges speedometer

Posted on 2011-09-26
3
405 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:teylyn
teylyn 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

760 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now