One variable X Axis, y Axis, with color coding legend?

Hi,

I'm trying to reproduce a chart that would look similar to this using Excel:

TestChart.PNG

I expect this is a scatter plot. But whatever I try doesn't seem to be workable, and I honestly can't figure out how to collapse it into one field for the X-Axis. I'm really struggling here.

• I've tried using standardize to create some kind of spread to space the points out -- doesn't work
• I've tried swapping rows and columns only to get series data which I can't work with

I have 3 columns of data:
ID (sample identifier)
pg/mL Value (0-1000) (y axis would be log10)
Grading (0-3)

I'd also like to color each data point based on the grading column also, using that as a legend of sorts. The horizontal bar indicating mean isn't required also.

Any help?