Separate Multi-Select Text Fields on a Pie Chart

I think that the flaw in Alex approach is that while you would be able to make a summary report (which may be good enough for your purposes) you not be able to make a pie chart as each record can only appear in one slice of the pie chart.

But you would be able to make a summary report, so maybe tackle that "easier" approach first and see if its good enough.