Speed meter

[Abhijeet]

Hi
I want speed meter in excel with the 10,20....to100 number in that meter will display

 

[Sajan]

Hello Abhijeet,
A Google search for "speed meter in Excel" came back with many hits, including the following:

http://www.instructables.com/id/Speedometer-Graph-in-Excel/?ALLSTEPS

-Sajan.

 

[NARAYANK991]

Hi Abhijeet ,

Can you check this link ?

http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm

Of course , it would be nice if you could go through this link also :

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

Narayan

 

[Abhijeet]

Can u send me file with my data

 

[NARAYANK991]

Hi Abhijeet ,

If it is not urgent ; I will take a day or two.

Narayan

 

[NARAYANK991]

Hi Abhijeet ,

I have gone through the article , and it talks of downloading an add-in which will do the job of adding the data labels ; this means that when you use the file , you will also have to download the add-in ; so will anyone else who wishes to use this feature. Is this acceptable ?

Narayan

 

[AVK]

I have attach one file. Which is helpful for you.

 

[Ahmed]

Hope the attached file will be helpful, this give you the pointer value as well... I am trying to get meter reading as required by you (like 0, 10, 20.....100 etc.)

 

[Ahmed]

• I have tried to add the meter reading as required by Abhijeet - as 0, 10, 20... 100
• Fore thinner meter reading pointers, you can reduce the values from 0.5 to 0.25 and from 9.5 to 9.75 in the meter reading table.
• Also you can format the meter reading values in different colors
• You can play with placement & format of the current pointer value.

 

[Abhijeet]

Thanks for this Ahmed