Two drop down lists, to produce in two other columns

Because you have text fields you cannot add them using the example in your table. You need to change your data in your table to numbers as I have done in my example. You can then do a simple =C2+D2 in E2.

You will be better served with a stacked Bar Chart. Pie charts look pretty but are worthless from an analytic perspective.

http://www.stevefenton.co.uk/Content...harts-Are-Bad/