The EVAL worksheet functions can also be used to return Mathematica graphics. Example | Result | =EVAL("ListPlot","Table[Random[],{50}]") | ExcelGraphic[1] | =EVAL("Graphics","Polygon[{{0,0},{9,3},{3,5}}]") | ExcelGraphic[2] | =EVAL("Plot3D","Sin[x+Cos[x y] y]","{x,0,4}","{y,0,4}") | ExcelGraphic[3] |
EVAL graphics examples. Mathematica graphics are displayed as picture objects in Excel. By default these pictures are rendered as Windows metafiles. This format scales reasonably well since it is a vector format. Font sizes, however, may become a bit distorted when a graphic is resized. If this happens, you can force the graphic to be re-rendered at its new size by recalculating its formula. Re-rendering the graphic will reapply any font size you have specified as a graphics option. Notes • It is the name of a graphic that associates it with a particular Excel cell. For example, if a formula in cell E10 returns graphics, the picture named "Graphic E10" will be updated on the same sheet. If no picture named "Graphic E10" exists on that sheet, a new graphic will be created. This is the extent to which the picture is "linked." When cutting and pasting a Mathematica-generated picture to another application or worksheet, this name-based "link" is not maintained. The copied graphic is simply a static picture. • By modifying the name of a picture, you can change which cell updates that graphic. To modify the name of a picture, you can select the picture and click in the Name box on the left-hand side of the formula bar. |
