Welcome to the Lounge

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

You're just being racist. Not all the chemicals are the same, stop being conditioned by your prejudices - there are good chemicals and bad chemicals just as in every category. And don't forget to ask each chemical the pronoun to use with him/her/it/them.

All I want to do is set up an X axis, set up a Y axis, and plot a line-scatter graph. It seems Excel can't do this with non-linear X values on a linear X axis - or I can't coerce it to do so. Either way, I have given up struggling with it, to the point where I am prepared to drop some valuable beer vouchers on the problem.

Thanks, but that's a bit like reinventing the wheel. I just have this bunch of data and need to display it in a graph outside the application, as a once-off. I was a bit gobsmacked that Excel couldn't do it. Somewhere there has to be something where you establish the X and Y axes of the graph from the max and min of the data, and then plot all the X,Y points from the dataset. The data collection points on the X axis are non-linear, but I need to display them along a linear X axis.

The salmon was exquisite, thanks for asking. Served with fresh asparagus and pasta shells, and accompanied with ice-cold Löwenbräu. If my coding were as good as my cooking, I would be richer than Bill Gates!

As for the rest of it, thanks, but I have decided to write an add-on to Excel to fix this problem, as I seem to recall having suffered from it before.

The scatter graph works fine for X-Y points, but the data collection points are equally spaced on the graph, where they are, in fact, non-linear to the point of being random. They are closely spaced at the start of the X-axis, becoming sparser further along - but they are essentially just points where data had been collected, and adhere to no mathematically defined function.

I want to impose a linear X-axis, say from 0 to 100, and have the graph points plotted along that linear axis. If I just use the X-Y data in a plot, then the X-axis is divided into equidistant points for the X value and the Y value plotted above it. If I add a third column of data to represent the X-axis, Excel accepts it but then draws two graphs, one for the X values and one for the Y values.

If it were not for the 11,000 odd data points, I would use a piece of graph paper...