Microsoft Office Tutorials and References
In Depth Information
After you create your chart, Excel makes is easy for
you to modify it or add details. In fact, you can
modify virtually all the elements of a chart. For
example, when you create a chart, Excel places it
on the same worksheet as the data from which you
created it. You can move the chart to another
worksheet or to a special chart sheet.
To make a 3-D chart easier to read, you can use
the X and Y fields in the 3-D Rotation dialog box to
change the chart rotation. The X field rotates the
horizontal axis of your chart and the Y field rotates
the vertical axis of your chart. In addition to
changing your chart’s rotation, you may also want
to change your chart’s perspective. Changing the
perspective is useful if the bars in the front of your
chart hide bars in the back of your chart. Use the
Perspective field in the 3-D Rotation dialog box to
change the perspective.
C HANGE C HART L OCATION
1 Click your chart.
l The Chart tools become
Click the Design tab.
Click Move Chart in the Location
l The Move Chart dialog box
Click New Sheet (
l Alternatively, click Object In
( changes to ) to place the
chart on another worksheet.
l If you click Object In, click here
and select the sheet on which
you want to place the chart.
Type a name for the sheet.