Layered Pie chart

[Excelquestion35]

Hi all,

I am trying to make a pie chart which shows the elimination of some volume, based on some criteria volume is lost.
By creating a pie chart I can only find the option to get a pie chart to show all volumes in one pie, however I would like to see a pie chart which shows the total volume 290247 and inside this pie the amount that is left with every criteria. More like a layered pie chart, is such a chart possible?

Inbound	Double single	Block/Euro	Weight	Overhang
290247	174148	140167	110284	105762
	80%	80%	79%	4%

This is the pie I get when I try it now, but the total pie is the sum of all these volumes combined, while it should be only the 290247.

 

[Kerryx]

Just rearranged your source data, select range A1:E3 and use that for your doughnut chart

Book1
	A	B	C	D	E
1	Inbound	Double single	Block/Euro	Weight	Overhang
2	290247
3		174148	140167	110284	105762
4		80%	80%	79%	4%
5
Sheet1