Ignoring Non zero Values and sort descending in a pie chart

[sujirpinna]

Hello Experts ,

I am creating a Excel PIE chart based of the below values . These percentages below are based of a SUMIF formula and may genuinely return Zero if there is no exposure. The range of the PIE chart is FIXED to the below 11 rows and two columns. My question is :

1) How do i make my PIE chart range dyamic to show only Non zero values . (If i dont , i see data Labels getting generated for all Zero values (6 observations from the below example) .
Currently i am going to "Select data" and deselecting the Zero value series.
2) How do i show the values in descending order automatically (without me sorting the below table descending on Col.B)
3) Below is how i would require the Final Pie to look like (Sort desending and Eliminate all Zero value observations)

38.5% - AUBasdad	38.5%​
28.2% - gbksada	28.2%​
13.1% - Boubasda	13.1%​
11.0% - ABC	11.0%​
9.2% - asdada	9.2%​
0.0% - sadfasdasd	0.0%​
0.0% - dsfsfsa	0.0%​
0.0% - dafsafdsa	0.0%​
0.0% - asfsafd	0.0%​
0.0% - asfdfas	0.0%​
0.0% - asfsfasf	0.0%​

 

[sujirpinna]

Pls help me with the above query

 

[kevin9999]

Because you have 365 on your profile, you can use the following method. Use the second table as your source data for your pie chart.

Book1
	A	B	C	D	E	F	G
1		Original data			Source data for Pie chart
2		AUBasdad	38.50%		AUBasdad	38.50%
3		gbksada	28.20%		gbksada	28.20%
4		Boubasda	13.10%		Boubasda	13.10%
5		ABC	11.00%		ABC	11.00%
6		asdada	9.20%		asdada	9.20%
7		sadfasdasd	0.00%
8		dsfsfsa	0.00%
9		dafsafdsa	0.00%
10		asfsafd	0.00%
11		asfdfas	0.00%
12		asfsfasf	0.00%
13
Sheet1

Cell Formulas
Range	Formula
E2:F6	E2	=FILTER(SORTBY(B2:C12,C2:C12,-1),C2:C12>0,"")
Dynamic array formulas.

 

[sujirpinna]

Thank you Kevin for your response . Pls would you know a method that does not involve creating a second table ?

 

[kevin9999]

You may be able to work the first table's formulas to do that, but I've no idea how that table's created. Could you share your sheet using the XL2BB add in, or alternatively share your file via Google Drive, Dropbox or similar file sharing platform?

 

[Peter_SSs]

In particular, what are the actual formulas that produce the table given in post 1?