Multiple data sets on one scatter graph?

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.

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.

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