A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can my colleagues modify my charts?



 
 
Thread Tools Display Modes
  #1  
Old February 10th, 2010, 11:47 PM posted to microsoft.public.excel.charting
hillmi
external usenet poster
 
Posts: 1
Default 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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.