i have created a pivot table having count's of data's in different range like 
below:
0-2	5
03-05	13
06-10	17
11-20	7
21-50	1
I want to calculate the percentage of the each data range and should dispaly 
in the chart. 

In EXCEL 2007 in the example that you have provided take the following 
actions:-

In your Pivot Table click in one of the cells that have a value in it (for 
example select the cell bearing the number 5). 

Go into the Values part of the PivotTable Field List (you will find this in 
the lower right hand corner). 

Click in the downwards facing arrow that is next to the word Number (I have 
Number as a field in my Pivot Table the other field being called Item). 

Select Value Field Settings (window of the same name will pop up). 

Show values as tab / In here change the:-

Show values as

 - setting from Normal to % of column. 

Hit OK. 

The values in your Pivot Table will now appear as follows:-

11.63%
30.23%
39.53%
16.28%
2.33%

If my comments have helped please hit Yes. 

Thanks!


"Muthu" wrote:

> i have created a pivot table having count's of data's in different range like 
> below:
> 0-2	5
> 03-05	13
> 06-10	17
> 11-20	7
> 21-50	1
> I want to calculate the percentage of the each data range and should dispaly 
> in the chart. 
> 
>