## Step 1: Insert Values

Value in cell B2

Max in cell C2

27 in cell B3 (exact value)

100 in cell C3 (maximum value)

## Step 2: Creating the Dial

Creating the Dial is simple. I used a doughnut graph to do that.

Doughnut in cell B12

180 in cell B13

30 in cell B14

150 in cell B15

Make sure cell B14 and B15 adds up to 180.

Select the 3 cells and create Doughnut graph from them.

Remove the legends

Change the doughnut angle and hole size to suite you. Mine was Angle=90 and hole size= 81%

Select the 180degree arc and set its fill to none.

In the same way set the other arcs to whatever color you require.

## Step 3: Graph for the speedometer pin

Enter

Graph in cell B5

0 in cell B6

0 in cell B8

0 in cell C6

0 in cell C8

Now for the real thing which will use the values in cell B3 and C3

Enter formulae

=SIN(((((B3+C3)*180/C3)+90))*PI()/180) in cell B7

=COS(((((B3+C3)*180/C3)+90))*PI()/180) in cell C7

## Step 4: Speedometer pin

Delete the legends and all except the graph line.

Open the primary horizontal axis and set the

Minimum to -1 (fixed)

Maximum to 1 (fixed)

Open the primary horizontal axis and set the

Minimum to -1 (fixed)

Maximum to 1 (fixed)

Set the graph's background to No fill

## Step 5: Finally

Change the value in cell B3 and the speedometer will show the same!

This is just a basic instructable. Change it as per your convenience as required.

**Signing Up**

This is wonderful and clearly described. I thank you and am using it.

Thank you! Appreciated!

This will be useful to create dashboards in excel itself.

From here

You can simplify the expressions to

B7: =-COS(RADIANS(((B3*180/C3))))

C7: =SIN(RADIANS(((B3*180/C3))))

Its really an easy way !!!

I've had a play around with this today: if one sets things up like in the attached pic, one can enter data (eg scores out of 20) on another sheet and have the graph reflect this. And yeah, there are many and better ways of setting things up, - as I said, just a play around!

Adding the Redline cell easily allows one to change where the red extends to, which might be useful if one has to use this graph for different criteria.

Well done artworker: I'd not have come up with that one on my own, so thanks! Any other graph tricks you can show us? I'd be keen...

For more fun with this you could play with the Data -> From Web tool- it gets the contents of part of a website into your spreadsheet. If the thing you want your dashboard speedometer to show is available on the web somewhere, you can probably get it this way.