Forum Discussion
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!
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/
3 Replies
- VahidDMSuper User
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/- darafatFrequent 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?
- Ashish_MathurSuper User
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.