From mboxrd@z Thu Jan 1 00:00:00 1970 From: Peter Davis Subject: Re: Trying to get chart from table working Date: Fri, 29 Sep 2017 17:32:09 -0400 Message-ID: <1506720729.1291151.1122958984.5896B03B@webmail.messagingengine.com> References: <951a16f3-142b-9a46-d205-e75e93b46fe9@pfdstudio.com> <87efqp8sob.fsf@pinto.chemeng.ucl.ac.uk> <1506699746.1209685.1122625320.2C7619C2@webmail.messagingengine.com> <1506699975.1210299.1122633688.70058F8C@webmail.messagingengine.com> Mime-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:33658) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dy2tL-0001HP-HL for emacs-orgmode@gnu.org; Fri, 29 Sep 2017 17:32:16 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dy2tH-0000S4-Hq for emacs-orgmode@gnu.org; Fri, 29 Sep 2017 17:32:15 -0400 Received: from out1-smtp.messagingengine.com ([66.111.4.25]:56925) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1dy2tH-0000QV-4Y for emacs-orgmode@gnu.org; Fri, 29 Sep 2017 17:32:11 -0400 In-Reply-To: <1506699975.1210299.1122633688.70058F8C@webmail.messagingengine.com> 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" To: emacs-orgmode@gnu.org I'm sorry to belabor this, but I could use some help. I'd be willing to pay a modest consulting fee, but I'm trying to solve a problem in a timely way, as it would help me with healthcare decisions. Basically, I want to plot a time series graph showing my PSA (prostate specific antigen) over time. The PSA is measured at irregular intervals, and has been for over 4 years (and hopefully will continue for many more years.) That should be a simple enough graph. I've already got a javascript d3 example that does this, but I'd like to embed it in a document, and to be able to generate PDF. Further, I want to be able to show different time intervals with tinted bands spanning the full range of the graph, and having specific start and end dates. These would represent various medical treatments I've undergone. I have a rough example I've mocked up in Photoshop, but, of course, I want to be able to add new data and re-generate the chart as needed. I don't know if I can attach a PNG to an email on this list. Unfortunately, I don't have enough emacs lisp knowledge, or org-mode knowledge, or gnuplot knowledge to know how to make this all work. I have not even be able to get the org-plot example to work. (I have been using org for various types of documents for a number of years, and can generally pick things up quickly, but I'm overwhelmed by this.) I was thinking of having a table like: ---- ... | *Date* | *PSA* | *Treatment* | | 2017-08-11 | 185 | | | 2017-08-21 | | #ffdd99 | | 2017-09-19 | 854 | #ffdd99 | ... ---- So some rows would contain a PSA measurement, some a background tint, and some both. I've never seen a visualization like this, but I think it would be very helpful to have a single timeline that shows periods of various treatments and the PSA value. There are probably better ways to specify the starting and ending dates of treatments, but this seemed amenable to simple iterative processing. I've considered possible tools for this, including d3, PostScript, etc., but I think Org would be best for maintainability, allowing me to add notes, etc. I know this is a tall order, but it's beyond my capabilities right now. Any recommendations or suggestions greatly appreciated. Thanks, -pd -- Peter Davis www.techcurmudgeon.com