Spreadsheet program?

[Robert Baer]

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??

 

[Ed Ferrero]

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.

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

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)

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.

What spreadsheet program can do this??

Excel

Ed Ferrero
www.edferrero.com

 

[Bill Sharpe]

Hi Robert,

Ok, I'll bite...

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


Use an XY scatter chart.


You mean copy to another position on the same spreadsheet? {Ctrl}-C
{Ctrl}-V will do it.


Add a title. Then click on the title, go to the formula bar and enter
=Sheet!A1 (or just enter = then select a cell)


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


Copy range to new sheet then Save As... and pick txt or dBaseIII or
whatever.


Excel

Ed Ferrero
www.edferrero.com

Excel 2007 no longer will save worksheets in dBase format. Excel 2003 will.

Bill

 

[Robert Baer]

* Thanks; see inline coments like this.

Hi Robert,

Ok, I'll bite...

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



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?

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)

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

 

[Robert Baer]

Excel 2007 no longer will save worksheets in dBase format. Excel 2003 will.

Bill

Almost "any" regular format will do, as long as i know what that
format is, i should be able to parse it for the info.

 

[Robert Baer]

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??

OK, 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.