I entered data from a classroom test. The answers were in A-B-C-D
format, rather than 1-2-3-4 format.

Now, I want a pie chart displaying the percent of the class that chose
'A', the percent that chose 'B', the percent that chose 'C' and the
percent that chose 'D'.

In statistical analysis software, this is brain-dead simple.
Unfortunately, Excel seems irked that I defined the answers with text
rather than numbers. I've tried a Pivot Table, but get an error,
because I'm only selecting one row of data.

Is there a simple way to solve this?

Thanks in advance...