I have excel file like below.
Address ID Physician Nurse Pediatric
ABC 1 5 6 8
DEF 2 6 4 3
GHI 3 5 6 7
I need a bar chart with count for Physician,Nurse and Pediatric.
I have to group Physician,Nurse and Pediatric into one field.How can I do this ?
Thank you very much.
If I understand your requeriment, you should do something like this:
CrossTable(Merge, Data, 2)
(ooxml, embedded labels, table is Hoja1);
That way, you can count by the Merge field.
Hope it helps.