 |
|
| Computers Forum Index » Computer Applications - Spreadsheets » Need spreadsheet...maybe not Hexcel... |
|
Page 1 of 1 |
|
| Author |
Message |
| Robert Baer... |
 Posted: Thu Apr 16, 2009 12:59 am |
|
|
|
Guest
|
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. |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Fri Dec 11, 2009 5:13 am
|
|