help with stacked bar chart using counts

[Anonymous]

Hi

I am having some trouble creating a stacked bar chart. What I want here is  Three stacked bar for each category (a,b,c), which are currently represented as columns and they are each stacked according to a different category. LIke this and code below.

https://www.dropbox.com/s/wifyfb2pyv77z0l/Sample%20Data%20-%20A.xlsx?dl=0

Thanks!

[Ashish_Mathur]

Hi,

How are nulls in column A different from blanks in columns B and C - are they the same?  Also, do you only want to count the TRUE's in each column or TRUES's and FALSE's in each column?

Please clarify.

[VahidDM · Accepted solution]

Hi @Anonymous 

Download this file: https://gofile.io/d/r7UAk2

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[darafat]

Thanks for your repsonse. It worked with me. One more question, if my data source is an online database. would unpivot for columns still work with any new data this is added to this online database?