Hello
I have to create a scatter graph with multiple data sets so that it looks exactly like the one in the image below.
My knowledge for excel is not quite good so any help would very appriciated.
Hello
I have to create a scatter graph with multiple data sets so that it looks exactly like the one in the image below.
My knowledge for excel is not quite good so any help would very appriciated.
Do you have the data values for the points on the graph?
Since the y-axis ranges increase at intervals of 20, it would be hard to recreate an exact copy based solely on "eyeballing" values.
Spread the love, add to the Rep
"None of us are as smart as all of us."
Yes, I do have separate data values. This image was shown by my lecturer as an example.
Can you be more specific? What exactly do you need help with?
Basic "how to create a scatter chart" https://support.office.com/en-us/art...rs=en-US&ad=US Having two data "sets" (Excel would call them "series") is simply a matter of adding additional columns/series (through the Design group -> Select Data dialog) as needed.
Table might look like:Please Login or Register to view this content.
Originally Posted by shg
Hello MrShorty, Thanks for your help. The problem is that there are no numbers in the x-axis instead I am supposed to label them like in this this image and I really don't know how to make a scatter graph with only values for y-axis. So everytime I make a graph points are spread out across the chart instead of them being grouped together like in the image.
Is a scatter chart appropriate then? Do you really want a line chart?
Perhaps a look at this discussion and the sample file I posted earlier today: http://www.excelforum.com/excel-char...ml#post3955964
You might also review this: http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html to see how to "mock up" a category axis on a scatter plot.
This isn't too complicated. Start with data as shown below, and insert a line chart.
BP001.png
Your four sets of BP data would look like this. Four sets for male/female, systolic/diastolic, plus one set for averages. The first column of each pair is centeredin a band within ±0.35 of 1, 2, 3, 4; note that 1, 2, 3, 4 correspond to the four categories of the line chart created above.
You could also do this with all of the data in two columns (these same four data sets end to end instead of side to side) instead of four sets of two columns, but I find this easier to work with even though it's a couple more steps below.
BP002.png
Copy the first shaded pair of columns, select the chart, paste special, adding the data as new series in columns, series names in first row, categories in first column. It's added as another line chart series and messes up the axis (first chart below). We'll fix all that in a minute.
Repeat this for the rest of the data pairs, including the averages (second chart below).
Change the chart type of the first added series to XY Scatter, without lines (third chart below). Repeat for the other three sets of individual values (fourth chart below).
Change the chart type of the average series to XY Scatter Lines without Markers (fifth chart).
Change the axis group of all the XY series to Primary (sixth chart).
BP003.png
Now all that's left is formatting. Format the original line chart series to hid it by using no lines and no markers. Format the individual BP measurements to use the same color and shape marker, and pick a good color for the average lines.
BP004.png
Jon Peltier
http://PeltierTech.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks