M
MSCom
Neuer Benutzer
Threadstarter
- Dabei seit
- 20.09.2016
- Beiträge
- 1
Dear Microsoft Community,
I have a problem regarding a block diagram in Ecxel, which I need for my bachelor thesis.
I made an interview where I got over 1000 answers per question. Now I want to compare these answers in a block diagram.
The problem is that in my x-axis I have now the numbers from 1-1000 and in my y-axis the answers which where given in numbers from 1-5 and as the two different colors my questions.
This diagram looks like a mess, because each number form 1-1000 has a block regarding to the given answer 1-5.
I would like to have it the other way around that I have the numbers 1-5 in the x-axis with the block diagram showing how many people have given this answer. And this with both questions so I can compare the number. Even better would it be if the y-axis with the numbers from 1-1000 are given in % form 1-100% in 25% steps.
I can´t develop this chart because it tells me that I have to many numbers (1-1000) that I can´t put those into the y-axis. So, does anyone now how to do this, or if it is even possible to design such a block diagram?
Thanks in advance!
Best regards
Dan
I have a problem regarding a block diagram in Ecxel, which I need for my bachelor thesis.
I made an interview where I got over 1000 answers per question. Now I want to compare these answers in a block diagram.
The problem is that in my x-axis I have now the numbers from 1-1000 and in my y-axis the answers which where given in numbers from 1-5 and as the two different colors my questions.
This diagram looks like a mess, because each number form 1-1000 has a block regarding to the given answer 1-5.
I would like to have it the other way around that I have the numbers 1-5 in the x-axis with the block diagram showing how many people have given this answer. And this with both questions so I can compare the number. Even better would it be if the y-axis with the numbers from 1-1000 are given in % form 1-100% in 25% steps.
I can´t develop this chart because it tells me that I have to many numbers (1-1000) that I can´t put those into the y-axis. So, does anyone now how to do this, or if it is even possible to design such a block diagram?
Thanks in advance!
Best regards
Dan