Block diagram in Ecxel

Diskutiere Block diagram in Ecxel im Office Forum im Bereich Microsoft Community Fragen; 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...

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
 
#
schau mal hier: Block diagram in Ecxel. Dort wird jeder fündig!
Registrieren bzw. einloggen, um diese und auch andere Anzeigen zu deaktivieren
Thema:

Block diagram in Ecxel

Block diagram in Ecxel - Ähnliche Themen

Change my ONLINE word language from german: My online office is in german, it asks if I want to change to swedish, I press yes but nothing changes. My account is set to sweden so how can I...
Outlook 2013 calendar entry hover preview not showing start/end time: Hello community I have a problem with my Outlook 2013. It's a new installation, and for some reasons I'm not able to see the calendar entry...
My Account got suspended/banned: Hello, my name is Tim and my Microsoft account has been banned. It has been banned due to my not having the phone number that I put in originally...
Forms Option "Other" to create new Forms entry: Hello everyone, I would like to automate my microsoft forms so that whenever a user selects "other" in a choice type of question, it...
powershell: remove owners from list of members in o365 group: I'm the admin for a shool, that uses O365 for administration as well as classes. We mainly use Teams. OneNote and Email. I created teams for...

Sucheingaben

live casino

,

best poker site

,

best pokeJr site

,
casino cast
, world of poker, charlestown casino, adult po9ker, hit it rich casinOo slots, poker images, pooker images, govenor of poker, poker tables for sale, double down caVsino free, best poker rooms in vegas, double down casizno codes, naked *poker, northstar casino, northstar Hcasino, zynga pNoker cheats, hard rock casino, hard rock casi[no, what is a full house in poker, double down casino free, govenor of 8poker
Oben