Using string data to create charts?

  • Thread starter Thread starter DW_Magus
  • Start date Start date
D

DW_Magus

For my class project, our group ended up doing surveys. We collecte
hundreds of them and then I manually entered the data into an acces
database.

I exported the database table as an excel worksheet so that I coul
make charts.

The problem is that all the data is in string format, and excel doesn'
seem to want to make charts using that. For example, we have
question that is multiple choice and there are 5 answers, each of whic
is a different word.

What I am trying to get Excel to do is where I select the column tha
the different answers are in and have it count up all the same answer
and turn it to percentages so I get a percentage of answer a, b, c, d
e in the form of a pie chart or another graph.

I would like to do this with more than just one set of data, and prefe
to be able to do this with two or three so that I may be able to mak
multiple comparisons in one chart.

Because the things I am trying to chart are not numerical, but instea
strings, I was wondering what to do.

I'm not really too sure on how to be any clearer, but I'm jus
wondering if Excel can do this or how to go about doing it.

Any help is appreciated, thanks in advance.

-Magus

PS, I apologize if this has been asked before, because I didn't hav
much luck finding an answer through the search
 
Look into creating a PivotTable. It can directly access the data in an
Access database.

--
[Posted directly to the Usenet newsgroup -- no affiliation with
Excelforum]

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
We just did something similar in my statistics class. In
order to simplify the information, we assigned a numeric
value to each word - this allows you to run the
statistical formulas to the data as well.

for speed, dumping the info to a spreadsheet, find and
replace the string with the number.
 
Thanks for all the help, I believe I can come up with a way with you
suggestions.

-Magu
 
Back
Top