From: timr Date: 2011-01-12T00:40:27+09:00 Subject: Re: Draw Line chart You could definitely do it with the ruby-processing gem, which can watch a script and update the graph live, so any data changes the graph is automatically updated. But you would have to build up the chart from scratch as nobody has built a framework for graphing (as far as I know). I haven't seen any graphing tools in pure ruby, and most people doing such scientific graphic end up just using python which has the numpy and scipy modules. Alternatively you can get your data into CSV format and import that into R, gnuplot, or excel and graph it easily. My favorite is R with the ggplot2 module. You can write an R/ggplot script and R to execute it from ruby using backtics as quotes (`R wrote: > Mike Stephens wrote in post #973911: > > > Fan Jin wrote in post #973892: > >> I still have some problems with get the Range from the > >> table which imported from the MS Access, cos I do not want to set the > >> range every time with new table imported. Please give me more hints with > >> how to do this, thanks. > > > Excel does have concepts of the currently active range etc without you > > necessarily telling it the details but I would be inclined to use Ruby > > to read the Access table into an array and then plonk the data into a > > range (rather than getting Excel to import it). It's just a simple > > assignment. Since you can find the number of rows retrieved, you can > > easily get Ruby to calculate the range. I guess that will be easier when > > you then get Ruby to request the Chart. Look at the Ruby on Windows blog > > to see how to access Access (Jet) - it's only a few lines of code. > > Thanks, that's very great! But after the data has been stored in an > Array,which gem can be used to draw a dynamic chart, please? > > -- > Posted viahttp://www.ruby-forum.com/.