Speedometer Graph

**venu_creative** · 06-20-2010, 07:47 AM

Dear Friends,

I have tried to plot a speedometer graph based on taking help from http://www.brainbell.com website. I have attached the file which consists of the graph. But the problem I am facing is, even though the input data (cell F3) is zero, the dial is still showing at 11 (or not equal to 0).
How should I make sure that the dial is showing as per Input data.
Would appreciate if someone could help on this.

With Regards,
venu.

**zbor** · 06-20-2010, 08:10 AM

Put in e2 180, not 200.

**Andy Pope** · 06-20-2010, 08:10 AM

Change E2 to 180 rather than 200. This details the angle of the dial.

**venu_creative** · 06-20-2010, 12:31 PM

Originally Posted by Andy Pope

Change E2 to 180 rather than 200. This details the angle of the dial.

Hi Andy Pope & zbor,

Thanks to both of you for your reply.
It would be great if you could explain the logic behind those calculations.
I didn't really completely understood the calculations for Bands, Dial, Dial Labels, Labels, Needle. Can it be a bit clear so that a layman can also understand?

Thanks in advance.

Venu