Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Modify Code | Excel Worksheet Functions | |||
Modify a UDF please? | Excel Worksheet Functions | |||
Modify a UDF please? | Excel Worksheet Functions | |||
Link diverts to c drive when emailed to colleagues | Excel Discussion (Misc queries) | |||
Can I email my colleagues automatically when i update a workbook? | Excel Discussion (Misc queries) |