|
|
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.
GCS d-- s-/++ a- C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
John Simmons / outlaw programmer wrote: furniture polish is made with real lemons...
Who's going to call them out if it turns out not to be true?
I'm not drinking Lemon Pledge just to find out...
|
|
|
|
|
… preferably free, but cheap is good too.
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.
If anyone has any suggestions, I would be very glad to hear them.
|
|
|
|
|
Not sure, but it may help: sketchometry[^]
"The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge". Stephen Hawking, 1942- 2018
|
|
|
|
|
Thanks for that - it looks useful, but I need something that I can import Excel or CSV data into. I have a LOT of data!
|
|
|
|
|
Add that info to your OP.
|
|
|
|
|
I'd use matplotlib and numpy/pandas in the python world.
numpy is a lower level high performance array structure.
pandas is a higher level data frame structure built on top of numpy
matplotlib is a graphing library that will take data frames and render a huge variety of visualisations.
Use an IDE like spyder and it's all quite easy and interactive.
And all free.
|
|
|
|
|
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.
|
|
|
|
|
|
I use the pirates favorite... R[^]
RStudio is nice IDE envirionment for R that makes it easier to use. You can import and export Excel and csv file easily. and there are plenty of support communities where you can find how-tos and examples.
RStudio – Open source and enterprise-ready professional software for R[^]
[Edit] - And it's open source.
It was broke, so I fixed it.
|
|
|
|
|
Thanks, but I really, realy, realy do not want to write one more line of code just to display the data just one time.
|
|
|
|
|
So, what your really, realy, realy looking for is some CODZ PLZ URGNTZZ?
It was broke, so I fixed it.
|
|
|
|
|
Nah! I don't need no CODZ PLZ URGNTZZ. Don't really like the stuff. I am actually having poached salmon in a lemon sauce tonight.
|
|
|
|
|
Is that with real lemons?
It was broke, so I fixed it.
|
|
|
|
|
Nah! Furniture polish - it's cheaper.
|
|
|
|
|
Chris C-B wrote: Nah! Furniture polish - it's cheaper. plus if you're grilling, you get the added bonus of that flame thrower touch of excitement, the kids will love it!
It was broke, so I fixed it.
|
|
|
|
|
So, how was the salmon?
Anyway I got 'yer Codez. It's like 6 lines of code.
# Install & Load Library
if (!require("readxl")) install.packages("readxl")
library("readxl")
# Choose & Read Excel file, the 2 denotes the desired sheet number.
my_data <- read_excel(file.choose(), 2)
# Extract data from the desired columns. RStudio will provide drop-down with column names.
Ydata <- my_data$Column_With_Ydata
Xdata <- my_data$Column_With_Xdata
# Plot data
plot(Ydata, Xdata)
As with any code you can get as fancy as you want, but for a one time look see...
It was broke, so I fixed it.
|
|
|
|
|
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.
|
|
|
|
|
I just plugged two sets of random numbers into Excel (2013) and produced a proper scatter plot. I followed these steps to get the trend line: trendline example. Is your data set too big for Excel?
if (Object.DividedByZero == true) { Universe.Implode(); }
|
|
|
|
|
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...
|
|
|
|
|
Scilab seems like the way to go. Several of my scientific co-workers use that for dealing with data sets doing all kinds of stuffs that physics does with data, including non-linear axes.
|
|
|
|
|
Thanks, I will check it out.
|
|
|
|
|
You could have a look at GNUplot, it certainly meets your requirement for free.
|
|
|
|
|
Having just Bingled that, it looks like it could be a winner - thanks.
|
|
|
|