Updating pie chart data in table does not update size of pie wedges

Hi,

In order to get your Pie Chart to respond to the data that is referencing other areas of the form you have to include the name of the sheet in the formula.
When starting from scratch you need to have a second worksheet in your file.
In this case just add another sheet.
When setting up your reference formula's, select your cell, then equals sign, then select the other worksheet, then back to the original.
You'll notice that the worksheet name is now in the formula. Now select the cell you want to reference.

Once all your cells are setup referencing other parts of the sheet, you can then insert and format your pie chart.
Now you can sort your list and it will properly reflect on your pie chart.

Attached is a version of your file.

Hope this makes sense and is helpful.

Cheers