H
hillmi
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.
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.