2012NASkater2012
New member
- Joined
- Jul 18, 2019
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
I've attached the excel for reference (sheet 1) - I am trying to create a pivot chart based on some survey results, but the x axis fields are not separating out how I want.
The question I am trying to build a pivot chart for has multiple select answers (so out of the 4 answers, a person could pick choices "a, b, c, d" or "a and b", or just "b". I want answers a, b, c, and d as distinct fields on the x axis, and then each bar would correlate to the "Count" of each of these fields. However, the x axis is instead showing me a|b|c, a|b, a|b|c|d, etc. based on the answers that each person has selected, so now I have over 10 bars. How do I make the x axis separate out to just 4 bars?
The question I am trying to build a pivot chart for has multiple select answers (so out of the 4 answers, a person could pick choices "a, b, c, d" or "a and b", or just "b". I want answers a, b, c, and d as distinct fields on the x axis, and then each bar would correlate to the "Count" of each of these fields. However, the x axis is instead showing me a|b|c, a|b, a|b|c|d, etc. based on the answers that each person has selected, so now I have over 10 bars. How do I make the x axis separate out to just 4 bars?