Plotting a single point on 'scatter-type' graph

**emmajayne** · 02-01-2023, 07:41 AM

Hi everyone,

I am pulling my hair out here with something that seems like it should be very simple!

I have one set of data:
Name and Oxygen level for 12 people

The client wants this plotted onto a scatter-type graph along with showing the desirable O2 range.

I want the data (O2 levels) along the X and names along the Y.

When I create this in Excel, it suggests a bar graph but I just want to plot a single point (like a scatter). I know for a true scatter you need a two data point for correlation but is there a way to just plot single points on excel agains names? Does this make any sense?!!

Thanks SO SO much in advance

**emmajayne** · 02-01-2023, 08:56 AM

Attachment 815895

Hi everyone, I think I have managed to do it - how do I change the axes around? And how do I add a 'desirable' range?

**MrShorty** · 02-01-2023, 10:18 AM

You attachment failed to attach, so I'm not sure what you currently have. What I see you describing in the OP is sometimes called a dot plot, which can be made in Excel by creating a combination scatter + bar chart. See tutorial here: https://peltiertech.com/dot-plots-microsoft-excel/