Microsoft Office Tutorials and References
In Depth Information
Creating shapes and mathematical equations
To change the order of the shapes, select the shape in the back, click the Format tool tab,
and then, in the Arrange group, click Bring Forward. When you do, Excel moves the back
shape in front of the front shape. Clicking Send Backward has the opposite effect, moving
the selected shape one layer back in the order. If you click the Bring Forward arrow, you can
choose to bring a shape all the way to the front of the order; similarly, when you click the
Send Backward arrow, you can choose to send a shape to the back of the order.
One other way to work with shapes in Excel is to add mathematical equations to their
interior. As an example, a business analyst might evaluate Consolidated Messenger’s financial
performance by using a ratio that can be expressed with an equation. To add an equation
to a shape, click the shape and then, on the Insert tab, in the Symbols group, click Equation,
and then click the Design tool tab to display the interface for editing equations.
TIP Clicking the Equation arrow displays a list of common equations, such as the
Pythagorean Theorem, that you can add with a single click.
Click any of the controls in the Structures group to begin creating an equation of that type.
You can fill in the details of a structure by adding text normally or by adding symbols from
the gallery in the Symbols group.