Sub categories in pie charts

[aerris]

Hello,
Can someone help me with what i hope is a simple query.

I want to make a pie chart and have subcategories.

So for example, I have the following data in a spreadsheet:

category	item	       amount
home	        rent	       100
essentials	food	        50
insurance	pet	         5
insurance	home	        10
insurance	car	        50
home	        carpet       	20

So the pie chart would look kind of like this:

Is that possible?

Thanks! :D

 

[Jon von der Heyden]

Hello and welcome to the board.

This article explains set-by-step.

 

[aerris]

Thanks!!