Multiple choice test data - How do I get Excel to deal with one row of data?

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...

.

Relevant Pages

  • Floppy Drive Keeps Reading
    ... read while I'm minding my business working. ... I'm told that, "there's no disk in floppy, would you like to format now." ... course I chose no but then went back and chose yes then it said,"no floppy in ...
    (microsoft.public.cert.exam.mcse)
  • Re: Combining separate Word documents into one document
    ... Chose the option the add new documents following a section break, next page which should enable you to insert each document and keep its format. ... I have many wide and varied formats ... that wants a combined Word version of this document. ...
    (microsoft.public.word.newusers)
  • Re: Labels
    ... In previous versions there was a Label facility from which one chose a ... format. ... The same feature is on the Mailings ribbon, ...
    (microsoft.public.word.docmanagement)
  • New installation problems
    ... I just recently reinstalled Windows XP Professional on top of the Home ... I chose not to format my hard drive. ... When I finished installing, I ...
    (microsoft.public.windowsxp.basics)
  • Converting Identification Number to Birthday
    ... first 6 digits represent the persons birth date. ... If the entered data is in the format of the Passport Number, ...
    (microsoft.public.excel.misc)