

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 howtos and examples.
RStudio – Open source and enterpriseready 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 CB 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 dropdown 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 icecold 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 addon 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 XY points, but the data collection points are equally spaced on the graph, where they are, in fact, nonlinear to the point of being random. They are closely spaced at the start of the Xaxis, 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 Xaxis, say from 0 to 100, and have the graph points plotted along that linear axis. If I just use the XY data in a plot, then the Xaxis 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 Xaxis, 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 coworkers use that for dealing with data sets doing all kinds of stuffs that physics does with data, including nonlinear 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.





I don't have a solution to offer, but I'm wondering if you could give some usable example data?(riggedup or otherwise) I certainly recognize that this simple need has arisen more times than I can remember. It's time to dabble in toolbuilding.
This kind of issue is a lot like when I only want to make a simple chickenscratch sketch using oldschool Paint but the system I happen to be using only has a major drawing program that takes toolong/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 freeorinexpensive options.
Pete K.





Pete Kelley wrote: This kind of issue is a lot like when I only want to make a simple chickenscratch sketch using oldschool Paint but the system I happen to be using only has a major drawing program that takes toolong/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 addon for access to solve precisely this problem.





At the risk of sounding dumb, I can't see the problem  what are 'nonlinear X values' ? You can't just mean they are at unequal Xintervals, because surely that is trivial, even for Excel?





See my reply to Foothill above. If you know of how it can be done, I would love to hear about it.





I must be being dumb. I read your reply above, could not visualise it. Although the chance of my being able to help is slim, could you post a scan of a scribbled hand plot to illustrate?





I found ZedGraph maybe 10 years ago, and have driven it with C# for countless graphing needs since then.





convert nonlinear to linear via log base 10, base 2, etc.





Regrettably, although the X data points are nonlinear, they are not nonlinear in a predictable way, rather a random spacing, more densely pack at the root of the Xaxis.





My apologies to those who replied yesterday, but did not get an answer. We currently have the builders in, converting my old office in the stables into a selfcontained flat, and what with shopping in IKEA, making tea for the builders, making sure they were following my plans, and visiting a couple of clients, the day just disappeared.



