Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

Drashboard Gauges speedometer

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
eduardo12fox
Asked:
eduardo12fox
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
eduardo12foxAuthor Commented:
OK! Very Well
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now