Prev: Standard Error Formula
Next: drawing shapes move when printing
From: hillmi on 10 Feb 2010 18:47
I write my analysis programs in Java.
I like java except for graphs of analysis results and raw time series data.
I have used the unmodifiable BufferedImage dot-matrix plots with fair results.

But I want to draw graphics that my colleagues can touch-up or modify, because
I can't predict everything they will want to show others or publish.
I had the idea of outputting comma separated text files to be read into
excel like:

@ECHO OFF
FOR %%A IN (%*) DO (
COPY %%A TEMPORAR.CSV
ECHO %%A
c:\"Program Files"\"Microsoft Office"\OFFICE11\EXCEL TEMPORAR.CSV
ERASE TEMPORAR.CSV
)

where the excel 2003 has a self-generated macro modified to link titles to
cells.
But I don't know how to unlink the chart, or if it would be modifiable then.

And when I want to glance over a lot of result graphs,
I have to do six clicks for each macro-produced graph where it seems like
I should be able to program for one click each.

I would appreciate suggestions on what software to use in my situation.
My original data are usually long time series.
Thanks in advance.

 | 
Pages: 1
Prev: Standard Error Formula
Next: drawing shapes move when printing