ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can my colleagues modify my charts? (https://www.excelbanter.com/charts-charting-excel/255997-how-can-my-colleagues-modify-my-charts.html)

hillmi

How can my colleagues modify my charts?
 
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.



All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com