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’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. 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? The only difference is a line graph has a. Scatter plots are similar to line graphs. What they want me to create is – from what I can tell – akin to a sunburst chart. A scatter plot gives you a visual idea of what is happening with your data. Microsoft excel does not automatically connect data points in scatter or line charts when there is missing data or empty cells (see excel example below). They will all be different whole numbers (the dataset at the moment goes from 8,000 to 57,000 and there are 9 groups. If you’re familiar with graphs, you might already understand that these points are referred to as (x,y) where.
One variable controls the position on the x-axis of a point, whilst the other variable controls the position on the y-axis. So A for example contains 5,000, B contains 7,500, C contains 10,000, and so on and so forth. A scatter chart plots the values for two variables as a set of points on a graph. I have a selection of Groups with different numbers within them. I falsely assumed that the workaround using regular charts was generally known within the Excel team. 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. The next question is usually OK great I can scatter chart my data points.
0 kommentar(er)
