Speedometer Chart Template in Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

Speedometer Chart Template

The QI Macros for Excel SPC Software includes a Speedometer Chart template to help you show process performance:

How to Create a Speedometer Chart

The template has several fields that drive the chart: Title, max, min, actual, last, plan, month, and name. It also has three fields (C5:C7) that divide the speedometer into red, yellow and green sections. The data below was used to create the chart above.

1. All input areas are in yellow or orange. 
   Cells C5:C6 contain comments describing how to change these fields.
   When you change a value it will change the corresponding item on the chart.
2. Title - changes the chart title
3. Min and Max change the starting and ending points of the dial
4. Actual - designates where the needle is
5. Last and Plan - change the values in the triangles but do not effect the chart
6. Month and Name - change values on the chart near the title
7. The orange input areas define the breaks between red, yellow and green. If you change one number the other two calculations will divide the area equally but this can be overridden.

The Speedometer Chart template is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!