I am trying to build a simple scatter plot type diagram with the example info in the excel file. I would like to just rate people on the first two questions 1-5 and that would be the x and y axis. Then I will just filter yes/no on the last two questions.
Anytime I try to make this I have issues with the row headers adjusting themselves in which 5 and 5 are down on the bottom right. It would look nice if the people who were 5 and 5 are in the upper right. (that would be more intuitive)
Also, there will obviously be multiple people on one spot and I want to show all of them and not sitting on top of each other.
Any help is appreciated and I am a semi-novice user.
Since the y-axis is a discrete field, you can't just go in an edit the axis like you normally would with a scatter plot. In this case, since there is a fixed domain of 1-5, you can easily manually sort the values to get the 5 and 5 folks in the upper right. Just right-click the measure on the rows shelf and select Sort...