Speedometer Chart

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

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

=sum(b3:b8)

=sum(F3:F4)

Insert >Doughnut chart > Blank chart > right click

Select data > Chart data range

Select first table (series level - end तक)

                ok

2. select donut chart > Right click

Format data series >Rotation- 270

Select botton part > Right click

 Format data point> fill > No fill

3. Select one by one and change colour

Red, Yellow , Orange , Green .

Select dount chart Cicle) >Add data lavel

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

Right click > format data labels  

 label option

categary name

valuue

close

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

4.  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. Instert value

Select Doughnut Chart

 Right Click

 Add data Labels

  Value