Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Modify Code Richard Excel Worksheet Functions 0 March 13th 08 08:19 PM
Modify a UDF please? Excel Helps Excel Worksheet Functions 2 January 23rd 08 09:40 AM
Modify a UDF please? Excel Helps Excel Worksheet Functions 0 January 23rd 08 12:10 AM
Link diverts to c drive when emailed to colleagues knghtrvn Excel Discussion (Misc queries) 4 April 9th 07 10:48 PM
Can I email my colleagues automatically when i update a workbook? Elusive Ade Excel Discussion (Misc queries) 1 December 1st 06 01:06 PM


All times are GMT +1. The time now is 09:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"