![]() ![]() ![]() I’ve tried it every which way I can remember (haven’t done scatter graphs for an age!) and can’t seem to make it do what I want it to do. I want the number to be along the X axis and the score up the Y axis and then to be able to have a single point where the two values intersect, then label those dots with the name of the group. I have been able to successfully graph my data, but now I would like to use my custom labels from the 'Label' column and present them on the graph. I’m sure I’m being really stupid on this one, but I have the same groups and the same numbers within those groups, but now each of the groups also has a score between 1 and 5. I am trying to make a scatter plot with two series as shown in the table below. In the options window, navigate to Select Data to change the label axis data. Zero will be the centre of the circle, and for the radius of the wedges to vary as well as the partial diameter of the wedge – does that make sense? Right-click the graph to options to format the graph. What they want me to create is – from what I can tell – akin to a sunburst chart. ![]() They will all be different whole numbers (the dataset at the moment goes from 8,000 to 57,000 and there are 9 groups. So A for example contains 5,000, B contains 7,500, C contains 10,000, and so on and so forth. I have a selection of Groups with different numbers within them. I haven’t been on here for a while but I’ve been tasked with creating two graphs from my data set which is really puzzling me.
0 Comments
Leave a Reply. |