Picharts

[Tayyab Hussain]

Hi-

I have 5 Percentages in a a column and I want individual Pie chart "Slice" against each cell, and the rest part Grayed out, some thing like this.

 

[NARAYANK991]

Hi ,

Something like this ?

Narayan

 

[Hui]

Narayan

The formula in B1 should be: =MAX(A:A)-A1
Copied down

 

[NARAYANK991]

Hi Hui ,

Thanks for the correction. My mistake.

Narayan

 

[Tayyab Hussain]

Hi-
Thanks for the Help but could you please explain the steps that how this was done.

Thanks

 

[Hui]

Each chart in column C is a chart of columns A & B

eg: A1 is 42,720

The total of Column A is 192,830
So B1 has 192,830 - 42,720 = 150,110

Select these 2 cells
Insert Chart, select a Pie Chart
Excel takes these numbers and Automatically converts them to percentages of the total of the two cells