Microsoft Office Tutorials and References
In Depth Information
Embedded charts are stored on the drawing layer, and you can take advantage of
the stack order to overlay one chart on top of another. Figure 6-4 shows an
example. The smaller chart is higher in the stack order than the larger chart, so it appears
on top. Note that the plot area of the larger chart is reduced in size and moved to
the far left of the chart area, leaving room for the smaller chart.
For more examples of combining charts by stacking, refer to Chapter 8.
Figure 6-4: The smaller chart is overlaid on the larger chart.
Excel lets you combine two or more objects into a single object. This feature is
known as grouping. For example, if you create a design that uses four separate
AutoShapes, you can combine them into a group. Then you can manipulate this
group as a single object (move it, resize it, and so on).
To group two or more objects, select all the objects and then right-click. Choose
Group from the shortcut menu. Later, if you need to modify one of the
objects in the group, you can ungroup them by right-clicking and selecting
Ungroup from the shortcut menu. This command breaks the object into
its original components.
You can also group one or more embedded charts. Doing so ensures that
the charts stay together and enables you to move and resize them together.