Copies the values, formulas and number formats of a region into a cache. On second call the contents is written to the destination cells as a duplicate. Thus cell references are not moved as in a usual copy and paste operation.
Documents formulas in input range. Can be a single row or single column Assumes the following input structure
(1) (2) <== created by this macro . '=(1) <== created by this macro Heading1 Heading2 <== input by user =formula1 =formula2 <== input by user and selected prior to running this macro
Select an m x n input range and click 3D Plot to activate a beautiful 3-D graphic of the selected range. Minimal scaling options on the x and y axis and generic labelling, but great coloring, contouring and interactive features. Ability to take a "snapshot" of the graphics, which is inserted into the spreadsheet (at the top left hand corner of the selected range) as a JPG file. Controls in the graphics window include:
left mouse - rotate image
right mouse - zoom in (upper half of image) and out (lower half)
w - toggle to wireframe view
s - toggle back to surface view
j - joystick mode
t - track ball mode
Some graphics cards aren't really upto this control; you need very good OpenGL support.
Toggles the scales from automatic, to tight xy, tight x, tight y, where tight is based on the actual max/min of the series in the chart. For xy plots only.
