freeware graphing apps needed

[Boris]

After YouTube, that's where I went.
Nothing. No answers to a post I put there either.

This REALLY should be simple but it seem not.

[Stoob]

You could maybe attach a sketch of what you're trying to do.

I'm sure I'm not the only one (I hope ) who isn't exactly sure of what you're after

[Boris]

X axis 0-500 cell values are not linear along the axis ie - 5, 10, 25, 50, 100, 300, 500
Y axis 0 - 210,000 are random generated numbers.

6 items - Line graph - all items shown against each other.

I have done the graph under CHART. But the length of the axis cells is not representative of the value ON the axis.
IE - 5 value is the same size as 200 value ( in width ) and this distorts the curve.

[MrMoo]

R or Gnuplot might be better suited for complicated statistics.

[Boris]

Looking at the documentation it doesn't show if you can take spreadsheet data and post it into the program. If you can then I would welcome that info before downloading and trying either.

[MrMoo]

Looking at the documentation it doesn't show if you can take spreadsheet data and post it into the program.

It appears to support a few different means,

R Data Import/Export

[zerocred]

By my understanding of your description I think this is what you want - a linear X scale.

The scatter graph (with line) is the way to go.

If you set up the cols vertically like below (though that is not necessary in excel) - and do a scatter graph with line through it as in excel you get the attached, rand_graph.png. The graph may not correspond exactly to the numbers cos excel recalculates randoms when you save a file. You can do smoothed or not...

You can do exactly the same thing in open office - except it sounds like your stuff is horizontal you may need to transpose the x and y to the vertical axis for graphing (i couldn't figure how else to do it in the minute I gave it). You do this by selecting the table then doing paste special with the transpose box ticked.

X Y
5 167595.9415
10 7583.173936
25 13669.81095
50 177869.8594
100 120854.3874
300 108593.473
500 55567.83547

With Frequency - it may not be exactly what you want but my point was you can set up your 'bin sizes' to correspond to your X value resolution. like so
bin frequency
0 0
10 2
20 0
30 1
40 0
50 1
60 0
70 0
80 0
90 0
100 1
...

Then you do a IF freq=1 then VLOOKUP (or HLOOKUP) or something from the original data to plug in the results to plot them.

The intervening values e.g. for 80 is zeroso it wouldn't work for a line graph only a histogram.


R can probably do everything and more. Helpfully mirrored by Shri on geoexpat. But if all you want is a graph, then open office.

[Boris]

I will try that and rewrite the data.