From mboxrd@z Thu Jan  1 00:00:00 1970
From: Ian Barton <lists@wilkesley.net>
Subject: Babel: Processing Tables - Ignore Some Rows
Date: Tue, 30 Oct 2012 16:05:48 +0000
Message-ID: <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: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:55922)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <lists@wilkesley.net>) id 1TTEKG-0001TZ-Jc
	for emacs-orgmode@gnu.org; Tue, 30 Oct 2012 12:06:06 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <lists@wilkesley.net>) id 1TTEK9-00031Y-Qq
	for emacs-orgmode@gnu.org; Tue, 30 Oct 2012 12:06:00 -0400
Received: from mail2.wilkesley.net ([109.74.196.44]:50358
	helo=li40-130.members.linode.com)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <lists@wilkesley.net>) id 1TTEK9-000314-KY
	for emacs-orgmode@gnu.org; Tue, 30 Oct 2012 12:05:53 -0400
Received: from [192.168.42.181] (unknown [149.254.186.123])
	(Authenticated sender: lists@wilkesley.net)
	by li40-130.members.linode.com (Postfix) with ESMTPSA id 351441928FE
	for <emacs-orgmode@gnu.org>; Tue, 30 Oct 2012 16:05:50 +0000 (GMT)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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

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.