Last time this came up you rejected Excel due to having too much data for a spreadsheet. I have since created an Excel spreadsheet with two 1.5 million datasets and plotted them in various combinations and graph types. Changing the graph took about 7.5 secs. It is essential to use keybord commands to navigate the changes as any mouse drag and drop did take far too long. I agree with you that this is not a sensible use of spreadsheets, but Excel can use data in a database as a datasource. You won't get better graphs.
Another tool I use is qtiplot. Among the graph types that can be selected here are vector graphs (those graphs of little arrows which look like compasses in a magnetic field). You can choose other types, but the graphs are not as good as those produced by Excel. If this is a business problem requiring a business solution then that solution is probably Crystal Reports. Crystal Report is a Reporting Application that can generate reports from various Data Sources like Databases , XML files etc. Sadly the output from glpk is not XML, but I have a program written in Ruby that converts csv to XML. Or it did, perhaps it will need changing for the modified glpk csv format. See for my dreams come true: http://www.threedgraphics.com/tdg/enterprise/sap/crce/?gclid=CO3zso-kmKICFRM_lAodyGQpXg and note: Change chart properties dynamically at runtime > ----- Original Message ----- > From: Noli Sicad <[email protected]> > To: "[email protected]" <[email protected]> > Subject: [Help-glpk] Mathprog > SQLite/MySQL > GNUPlot - (Graphing LP and > MIP results) > Date: Fri, 11 Jun 2010 12:59:31 +1000 > > > Hi, > > I have trying to find easy way to render business graphs from my > MathProg MIP and LP results. R package works quite well but you have > to prepare the in advance what sort of graphs to you like to have. > > What really we need is dynamic graphing compatibilities similar to > ILOG ODM studio. > > I think lately gnuplot supports SQL statement, if I am not mistaken. > > Anyway, here what I found below > > Generating Graphs with gnuplot, Part 3 Sqlite3 > http://www.linux.com/news/software/developer/26873:generating-graphs-with-gnuplot-part-3%3E > > GNUplot from sqlite3 using plot special-filename > http://schwehr.org/blog/archives/2009-05.html > > Using GNUPlot to chart MySQL data > http://www.krazyworks.com/using-gnuplot-to-chart-mysql-data/ > > Or anybody doing this already? > > Noli > > _______________________________________________ > Help-glpk mailing list > [email protected] > http://lists.gnu.org/mailman/listinfo/help-glpk > -- _______________________________________________ Surf the Web in a faster, safer and easier way: Download Opera 9 at http://www.opera.com _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
