Speedometer Chart

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

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

Table :1         

Table :2

Table :3

1step- Insert Chart

Insert menu >Doughnut chart > Blank chart > right click> Select data > Chart data range

Select first table (series level - end तक)

                ok

2 step- Rotate Chart

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

Select bottom part (green part)> Right click > Format data point> fill > No fill

- Doughnut hole size arjust

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 bar(green part)>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

बाहर वाला 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

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

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

8 Step-  Center value add करना 

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

 = Select pointer Amount - 25

And set size and color