A should be simple graphical function

[TwistedHelix]

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

[Pauleyb]

Have you looked at PyPlot? It can do what you want, but it is a programming tool, which you may be more comfortable with. http://matplotlib.org/gallery.html

As for Excel, you need to use a line plot. Let's say you have your data like this:
London 0 1 2 8 4
NewYork 0 3 5 6 8
Paris 0 1 3 4 9

The first column of 0 is required and is your 'dummy' row so that your y-axis starts at 0.
Plot that data as a line plot with markers. You may need to hit the 'Switch Row/Column' button in the Chart Tools->Design tab. That should put the city labels along the x-axis and then have the appropriate points above each one. Now you need to get rid of the lines and make the markers into whatever you want (I chose orange dots). You will need to right click each line (series) and then choose to have no line and change the marker to what you want. That is tedious. I wrote a quick macro that will go through each series of the active chart and do that for you:

Please Login or Register  to view this content.

I wrote that code with no real error recovery or intelligence. You MUST select the chart you want to change (just click on it) and then run the macro. You will then need to do the manual task of right-clicking on the markers on the x-axis (i.e. the 0's) and making the markers 'None'.

I have attached a sample spreadsheet (with the macro - called LineChange) to get you started.

Note: to run macros you probably need to enable the 'Developer Mode' in Excel. Google the web and you will find a website with pretty pictures to show you how.

[Andy Pope]

Just create a normal scatter using your numeric data and then add some dummy series to label the horizontal axis with descriptive text via data labels.