Speedometer Chart

Speedometer Chart हमारे  Excel Presentation काफी बढ़ा देता है यह काफी Intresting chart होता है 

जब हमे किसी का Comparision बताना हो तो हम speedometer chart का use कर सकते है

* Pointer setting- Performance Level - Pointer setting (Pointer and tickness cell)

=sum(b3:b8)-=sum(F3:F4)

1step- Insert >Doughnut chart > Blank chart > right click> Select data > Chart data range

Select first table (series level - end तक)

                ok

2 step- select donut chart > Right click > Format data series >Rotation- 270

Select bottom part > Right click > Format data point> fill > No fill

3 step-Select one by one and change colour Red, Yellow , Orange , Green .

Select dount chart Cirle) >Add data lavel

यहाँ No दिखेंगे  > Click on numbers

Right click > format data labels > label option

Tick category name

Untick value

close

double Click on start and delete same max को भी delete

4 step- Create Second Layer 

Select chart> Right click > Select data > add

Series name ® Amount label

Series value ® Series labels

 (Only 10 wali series)    

इससे Second layer भी आ जाता है

- Select Bottom Par>Right Click > Formet data point> Fill >No Fill  

Change Second Layer Colour - Grey Colour (light and Dark)

5 step-Insert value

Select Doughnut Chart 

 Right Click

 Add data Labels

इसमें Values आ जाती है

(double click on chart value)

 Change par Number Manually

6 Step - Create Pointer

 Select chart > Right click > Select data > Add 

Series Name - Pointer (Table से )

Series Value - Amount range select

                     55

                      1

                   144

                  ok

बाहर वाला circle select 

           Right click 

Change series chart type 

            Pointer  में  Select Pie  chart (First)- ok

   Outside part select > Right click > No fill

    Rest blue part select > Right click -No fill

 7 Step-  Arjust pointer

Select Pointer >

   Right Click > format data point >

   Series option - angle of first slice - 270 >

    Change pointer color black

8 Step-  Center value add करना 

Insert > Shape>Text box > Draw Box > Click on formula bar

 = Select pointer Amount - 25

And set size and color