Is it possible to Count text in columns and t...

[George_J]

Is it possible to Count text in columns and the results in a COL Series Chart?

Example: Dept

Agree

Disagree

inProgress Finance

Yes Accounting

Yes Finance

Yes Sales

Yes Sales

Yes Accounting

Yes Accounting

Yes Accounting

Yes

So for my COL Series I would like to count each column and give the results for the department.

Finance will have 2 stacks displaying 1 for Agree and 1 for Disagree.

Accounting will have 3 stacks displaying 2 for Agree, 1 for Disagree, and 1 for inProgress.

Sales will have 1 stack displaying 2 for Agree.