ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Speedometer Charts (https://www.excelbanter.com/excel-discussion-misc-queries/152949-speedometer-charts.html)

The Rook[_2_]

Speedometer Charts
 
How do I do a Speedometer chart in Excel?

JLatham

Speedometer Charts
 
Jon Peltier has some information on making them at:
http://peltiertech.com/Excel/Charts/Speedometer.html


"The Rook" wrote:

How do I do a Speedometer chart in Excel?


Ron Coderre

Speedometer Charts
 
Hopefully, Jon won't mind that I used his instructions and partially
automated a speedometer chart. (I keep forgetting to ask him) It can be
downloaded from this free website:

http://www.savefile.com/files/904923

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP


"The Rook" wrote:

How do I do a Speedometer chart in Excel?


Jon Peltier

Speedometer Charts
 
Keep in mind that charts of this type are attractive but ineffective at
conveying information. They show very little data in a large area, the data
must be interpreted by estimating an angle (which human perception is not as
good at as estimating length of a bar or position of a point), they show
only one point in time (or multiple points but not along a time series), and
they are very easily misinterpreted. An effective business dashboard chart
is not a bunch of data mocked up to resemble a 747 cockpit.

Your data would be clearer and more concise plotted as line or column
charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"The Rook" wrote in message
...
How do I do a Speedometer chart in Excel?





All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com