Bar chart help.

[apthansh]

I have the data as below Sample

ID  Lend   Borrow   Spend    

1     Yes     No         Yes

2     No      Yes        No

3     No      Yes        Yes

I need to create a stacked bar chart where each bar will represent the type of Expense and it will show the count of Yes and no in the stacked bar.

How can I do this ?

Thanks much.

[migueldelval]

Hi  AnsH

Maybe you can use "count" at the expression definition (=count(Lend).

Good Luck

[sunny_talwar · Accepted solution]

Try CrossTable load:

Table:

CrossTable(Type, Flag)

LOAD * Inline [

ID,  Lend,   Borrow,   Spend   

1,     Yes,     No,         Yes

2,     No,      Yes,        No

3,     No,      Yes,        Yes

];

[apthansh]

Awesome Sunny. Thank you very much. Appreciate your time and help.