Charts from columns of text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can create charts from data that takes the form of numbers but can't work
out how to do bar charts when there's text, e.g. the following: Column A has
30 cells that contain either 'Patient', 'Relative' or 'MP'. I want a bar
chart that has these labels along the bottom and the number of times they
occur up the side.

Column B has the same number of cells and contains either 'Upheld', Not
upheld', 'Withdrawn' or 'Pending'. I want a bar chart that shows how many
times the column B categories occur for each category in column A. Sorry
this is so detailed. Can I do it?

Many thanks
Chandler
 
Back
Top