Hi All.

I have performed a set of statistical analysis (ANOVA) in minitab - easy.
I then went on to make a scatterplot with groups to graphically show the spread of the data within the treatments vs the response

However minitab only allows numerical data, so in my study, my treatments are labelled as "1", "2", "3" and "4". The powers that be are too moronic to understand the key of 1 = cosynch and would rather I name them by the name, and not use numbers.

So I go to excel to perform a scatterplot with groups - a simple function I achieved in minitab in literally 3 seconds, albeit with numbers rather than names

However, Excels scatterplot with groups....isn't a scatterplot with groups. I appreciate excel is more of a business tool than an actual mathematics tool - but it works atrociously, it keeps trying to put the actual data on both axis (linear regression scatterplot)

See attached pictures.

I basically want the minitab scatterplot but the X axis with names - not numbers.

How do I do this in Excel? I have looked for tutorials but they are all labelled as scatterplots when they're not true scatterplots with groups as seen in the minitab chart, they keep tutorialling regression scatter graphs.

I have spent hours on this, it is a very simple task, why excel cannot take my row of names and column of numbers and simply express it as minitab does is beyond me. I have tried selecting the data and literally highlighting what I want in the X axis and Y axis but it states an error and how it is impossible (it isn't, I have seen it in Excel a few times, and I did it on minitab within seconds).

I have mapped it out in the excel cells in every way possible and have even tried making the chart from scratch where you simply add it all in manually into the select data options - it has a ***** fit and thinks it can't be done.

I really, really hate Excel. I have used SAS, R, minitab, and all manner of statistical tools with ease, and Excel shits itself on a basic scatterplot with groups (important that it is a scatterplot with groups. I swear if I see another tutorial of someone doing LINEAR REGRESSION scatterplot and naming it a scatterplot with groups I am going on a maths bitchfit)

I am NOT interested in R^2 or y intercept. I simply want a graphical representation of the spread of data as datapoints with NAMES on the X axis - Some godlike Excel user please tell me how to do this.

A simple way would be to simply use MSPAINT to change the numbers in Minitab chart to names - but eh, I should at least try to learn Excel, despite my absolute hatred of it.

http://i72.photobucket.com/albums/i1...g?t=1429482010

http://i72.photobucket.com/albums/i1...g?t=1429482629