Cross table help

[#1]

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.

[sunny_talwar]

This may be?

Table:

CrossTable(Group, Value, 2)

LOAD *;

LOAD * Inline [

Address,  ID,  Physician,  Nurse,  Pediatric

ABC,      1,      5,              6,        8

DEF,      2,      6,              4,        3

GHI,        3,      5,              6,        7

];

[andrespa]

Hi Pavana,

If I understand your requeriment, you should do something like this:

CrossTable(Merge, Data, 2)

LOAD Address,

     ID,

     Physician,

     Nurse,

     Pediatric

FROM

(ooxml, embedded labels, table is Hoja1);

That way, you can count by the Merge field.

Hope it helps.

Cheers,

Andrés

[miguelbraga]

More like this Sunny T

Using your quick solution.

[#5]

I agree with Andrés. Good idea!!!!

[miguelbraga]

Or if you want a horizontal stacked bar char like this:

Do you want the groupshowing as a cyclic group?