* Thanks; see inline coments like this.


Ed Ferrero wrote:

Hi Robert,

Ok, I'll bite...

I guess you're asking if Excel can do these things. My answers in line.

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).


Use an XY scatter chart.
* Which version(s)? I have M$ Office 2000 Premium; perhaps i missed the
how, as XY seemed to work only for one variable?


* 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!


You mean copy to another position on the same spreadsheet? {Ctrl}-C
{Ctrl}-V will do it.
* If the copy is EXACT this will do as a work-around. Would like to have
a script to do that as i need to make about 50 graphs (yes, all in same
spreadsheet but can be on another page/sheet)


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!


Add a title. Then click on the title, go to the formula bar and enter
=Sheet!A1 (or just enter = then select a cell)
* The graph starts with titles, legends, etc.
Want to be able to make changes via a program, NOT manually; have 50
graphs...


3) via program/macro, export graph in BMP or GIF format and SIZE it


Suggested procedure (in Excel VBA) is
- Copy chart to picture
- Build empty chart scaled by enlargement factor
- Copy picture to temp chart
- Export temp chart
- Delete temp chart and picture

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!


Copy range to new sheet then Save As... and pick txt or dBaseIII or
whatever.
* Via a program / micro?

What spreadsheet program can do this??


Excel

Ed Ferrero
www.edferrero.com