Help me create a scatterplot that isn't ugly and bad
February 27, 2011 4:51 PM Subscribe
Better-looking scatterplot using data from an OpenOffice calc spreadsheet?
posted by RobotHero to Computers & Internet (4 answers total) 1 user marked this as a favorite
I've got over 4000 rows of data in a spreadsheet and wanted to try some different graphs to show any correlations it may have.
I opened the spreadsheet in Open Office, and tried making a scatterplot chart using two columns. But the default "plot" on the scatterplot is a 10x10 square, which is really big for the number of plots I want on the graph. And I couldn't find any way to change the size of those to something smaller.
Are there a bunch of settings in Open Office I'm missing? Or is there a different program I should use that is devoted to making graphs that could import something like a .csv file?
Ideally, I think I want tiny dots for plots, possibly with some semi-transparency, to make sure I can still visually tell very dense from extremely dense. Bonus points if I can set colours for the dots based on a category from a third column of data.