OT: Spreadsheet program (maybe not Hexcel)?

Need spreadsheet not unlike Quattro-Pro.

  • Must be able to graph 2 variables (eg:volume, temperature VS time) and show each with its own grids in its own colors with scales in same colors (eg: one on left, other on right).
  • Absolutely !MUST! be able to do all of the following:
1) copy a graph to a (given, programmed) position ..and i mean COPY - NO changes of font or anything else! 2) via program/macro, to change title(s) obtained from given cell(s) ..and i mean change text ONLY - NO changes of font or anything else! 3) via program/macro, export graph in BMP or GIF format and SIZE it 4) via program/macro, export a range of data, preferable in TEXT format if TEXT was designated, or dDASE3 format if dBASE3 was designated ..and i mean NO OTHER FORMAT than the designated one!

??? What spreadsheet program can do this??

In Hexcel, i have the 2 variables graphed, each with its own color and it looks reasonable. Manually i can copy it and the copy looks just like the original (SUPER!). BUT...

1) I want the copy & paste to be in a macro that puts each copy in a (different) calculated position. 2) I want to have a program or macro that changes the chart title for a given copy, name available in a column elsewhere in the spreadsheet. 3) I want to have a program or macro that changes the Y values for both series for a given copy on a calculated basis. 4) I want to have a program or macro that (in effect) exports a given chart in GIF format, say same size as chart - then all i have to do is fiddle with chart size for external fit.

Ed Ferrero suggested that i copy a chart to a picture (please eXplicitly tell me how to do this). Then make empty temp chart scaled as needed (OK here). THen copy picture to temp chart (please eXplicitly tell me how to do this). And finally Export the temp chart (please eXplicitly tell me how to do this).

Thanks.

Reply to
Robert Baer
Loading thread data ...

e!

do

o

Microsoft Excel 2003 can do everything you ask, if you are willing to write a macro. Let me know what specific areas you like coaching in and I'll try to help. Regards, Jon

Reply to
jd_lark

ElectronDepot website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.