Microsoft Office Tutorials and References
In Depth Information
As you hide each chart object, make sure that you do nothing to
change the structure of the chart. For example, if you remove the
labels rather than turning them white, your chart would change
shape. You want the labels to exist in the first chart, you just don’t
want to see them.
The second chart object is the reverse of the first. It displays what
you previously hid, and hides what you previously displayed. Also,
you make the second chart transparent. To do so, select its chart
area and choose Format, Selected Chart Area. In the Patterns tab
of the Format Chart Area dialog, set its Area to None.
For the final step, you must exactly position the second chart object
on top of the first. You do this by positioning the first chart object
exactly within a range of cells; then you position the second object
in the same range.
The easiest way to do this is to press the Alt key as you click and
drag the first chart object. As you do so, the chart will jump from cell
to cell, positioning its top-left corner exactly in the top-left corner of
a cell. Once that corner is positioned, click and drag the chart
object’s bottom-right corner while pressing Alt. Then arrange the
second chart object similarly.