Speedometer Chart

  • Thread starter Thread starter Patty2005
  • Start date Start date
P

Patty2005

I want to create a speedometer chart for the following data
Actual Hours
12
Target Hours
15

The data is just from one row.I might have many rows and each will hav
a separate chart.

I used the following example from Jon Peltier's website but I don'
know whether the process of creating the donut chart is the sam
regardless of what data I have or Does it change depending on the dat
I listed above.

In my speedometer chart I want 12 and 15 to be displayed and also th
area should be shaded inside

Please help with procedure!!!!

Thanks !!!!
 
Doh! I didn't read your whole post.

You don't say exactly what your scale will look like, but with a target
of 15. I might use a scale of 0-10 red, 10-15 yellow, and 15-20 green.

Where my example has these numbers:

Numbers Donut Blank Fill Color
-5 5 Red
0 15 Yellow
15 10 Green
25 30 Blank

you would instead use:

Numbers Donut Blank Fill Color
0 10 Red
10 5 Yellow
15 5 Green
20 20 Blank

Then later where you do the calculations, this:

Angle = (12 - (-5)) / (25 - (-5)) * PI()
= 17 / 30 * PI()
= 1.78 Radians (102°)

should change to this:

Angle = (12 - (0)) / (20 - (0)) * PI()
= 12 / 20 * PI()
= 1.89 Radians (108°)

At some point I'm going to make an add-in to make the calculations and
draw this kind of chart automatically, but don't hold your breath. I
have some paying customers I have to take care of first.

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

Jon said:
Patty -

You might find this example useful:

http://peltiertech.com/Excel/Charts/SpeedometerXP.html

Andy Pope has a simpler one on his web site, without the shading:

http://andypope.info

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Click to expand...
 
Thanks!! Jon
But I am trying to find the scaling and also axes,does it start from
to 1 in my case.In your example your axis was -1 to
 
Hi Patty -

The scaling for X and Y axes in the XY Scatter chart piece of the thing
have to be -1 to +1 (or at least symmetric, from -Z to +Z). This keeps
the origin in the center of the donut.

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