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