Charting Non-Numerical Data

  • Thread starter Thread starter chornbeck
  • Start date Start date
C

chornbeck

I have a rather large xls full of customer data. I'm trying to produce
some charts based on the data. THe problem I'm facing is that the data
is non-numerical and I have little experience manipulating this type of
data.

I have several columns, such as State, MaritalStatus, and the like,
that I would like to find out info about, such as the percentage of
customers in each state.

How do I even begin to do this? Thanks for any helP!
 
I don't have much experience with non-numerical data, but I have used this
before:

=COUNTIF(B2:B21,"sc")

If sc appears in the given range, it will count it. Divided by the number
of customers*100 (=C2/(COUNTA(A2:A21))*100) will give you the percentage of
customers in sc...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Some chart types cannot be combined... 1
Help desperately needed with excel charts 10
Sum of non-numeric data on multiple sheets 3
Blank Values in Excel Charts 7
VBA Code to Export Data from Chart 4
Automatically shift chart data range 4
Data Validation Problems with Charts 1
Automatically shift chart data range: redux 6

Back
Top