Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

help with stacked bar chart using counts

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!

3 Replies

    • darafat's avatar
      darafat
      Frequent Visitor

      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?

  • 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.