From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ian Barton Subject: Re: Babel: Processing Tables - Ignore Some Rows Date: Wed, 31 Oct 2012 15:46:01 +0000 Message-ID: <509147B9.6030200@wilkesley.net> References: <508FFADC.8000607@wilkesley.net> Reply-To: ian@manor-farm.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([208.118.235.92]:44431) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1TTaUk-0005C9-Uv for emacs-orgmode@gnu.org; Wed, 31 Oct 2012 11:46:24 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1TTaUX-00041o-Tv for emacs-orgmode@gnu.org; Wed, 31 Oct 2012 11:46:18 -0400 Received: from mail2.wilkesley.net ([109.74.196.44]:52183 helo=li40-130.members.linode.com) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1TTaUX-00041N-Nl for emacs-orgmode@gnu.org; Wed, 31 Oct 2012 11:46:05 -0400 Received: from [192.168.0.58] (unknown [46.33.134.31]) (Authenticated sender: lists@wilkesley.net) by li40-130.members.linode.com (Postfix) with ESMTPSA id 202E01928FE for ; Wed, 31 Oct 2012 15:46:03 +0000 (GMT) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org Thanks Thomas that works fine. Can you point me to where indexable variables are documented, as my feeble search skills seem to be faiing. Ian. On 30/10/12 16:25, Thomas S. Dye wrote: > Aloha Ian, > > Will indexable variable values do what you want? Something like :var > data=monthly_total_mileage[0:-3,]? > > hth, > Tom > > > Ian Barton writes: > >> I am using gnuplot to plot some data from a table: >> >> #+tblname: monthly_total_mileage >> |-------+----------| >> | Month | Distance | >> |-------+----------| >> | Jan | 272.04 | >> | Feb | 317.11 | >> | Mar | 354.27 | >> | Apr | 288.21 | >> | May | 488.35 | >> | Jun | 444.92 | >> | Jul | 497.21 | >> | Aug | 625.35 | >> | Sep | 821 | >> | Oct | 717.9 | >> | Nov | | >> | Dec | | >> |-------+----------| >> | Total | 4826.36 | >> |-------+----------| >> >> >> #+begin_src gnuplot :var data=monthly_total_mileage :file >> ./monthly_total_mileage.png >> reset >> >> set boxwidth 0.5 >> set xlabel 'month' >> set ylabel 'distance, km' >> >> plot data u 2:xticlabels(1) notitle with boxes fs solid 0.5 >> #+end_src >> >> Ideally I want Babel to ignore the Totals row, so it doesn't get >> processed and plotted by gnuplot. Is there any way of doing this? I want >> to publish the data in several formats, some of which require me to >> display the total and some of which don't. >> >> Any other workarounds gratefully accepted. >> >> Ian. >> >> >