Suggestions for graphing software...
-
So, what your really, realy, realy looking for is some CODZ PLZ URGNTZZ? :laugh:
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. :laugh:
Is that with real lemons?
It was broke, so I fixed it.
-
… 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.
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(); }
-
Is that with real lemons?
It was broke, so I fixed it.
-
Chris C-B wrote:
Nah! Furniture polish - it's cheaper.
:laugh: 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.
-
… 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.
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.
-
… 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.
-
… 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.
I don't have a solution to offer, but I'm wondering if you could give some usable example data?(rigged-up or otherwise) I certainly recognize that this simple need has arisen more times than I can remember. It's time to dabble in tool-building. This kind of issue is a lot like when I only want to make a simple chicken-scratch sketch using old-school Paint but the system I happen to be using only has a major drawing program that takes too-long/forever to load up. Or I just want to type a sentence and a bloated word processor starts loading. Great to have some of the suggestions - checking out GNUPlot and some of the free-or-inexpensive options.
Pete K.
-
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, 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_XdataPlot 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.
-
… 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.
-
… 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.
-
… 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.
-
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! :sigh:
-
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.
-
I don't have a solution to offer, but I'm wondering if you could give some usable example data?(rigged-up or otherwise) I certainly recognize that this simple need has arisen more times than I can remember. It's time to dabble in tool-building. This kind of issue is a lot like when I only want to make a simple chicken-scratch sketch using old-school Paint but the system I happen to be using only has a major drawing program that takes too-long/forever to load up. Or I just want to type a sentence and a bloated word processor starts loading. Great to have some of the suggestions - checking out GNUPlot and some of the free-or-inexpensive options.
Pete K.
Pete Kelley wrote:
This kind of issue is a lot like when I only want to make a simple chicken-scratch sketch using old-school Paint but the system I happen to be using only has a major drawing program that takes too-long/forever to load up. Or I just want to type a sentence and a bloated word processor starts loading.
'Twas always thus! In fact, although I said I didn't want to write a line of code, I am now thinking of writing an add-on for access to solve precisely this problem.
-
At the risk of sounding dumb, I can't see the problem - what are 'non-linear X values' ? You can't just mean they are at unequal X-intervals, because surely that is trivial, even for Excel?
-
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_XdataPlot 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! :laugh: 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.