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?
Bookmarks