It's driving me nuts. I have a CSV with a bunch of dates & times, followed by a numerical value a few columns over. Format is as such: 2007-07-23 17:27:00,,,,,,100.00 (there's data in the other columns as well but I'm not interested in that). I'd like to make a simple histogram out of it but I can't seem to get OO.o to do that: it just takes n lines, divides the X axis into n equal parts and plots the values accordingly. What I want it to do is to take a fixed X axis and plot the dates & times in such a way that two datapoints for something that happened within a five minute interval are proportionally closer to each other than two that happened with a 2 hour interval. I've been poking and prodding it of and on for a couple of days now, but I cannot get it to do that.
Any suggestions for getting OO.o to do this, or for alternative software that can do what I want, would be much appreciated. |
