Microsoft Office Tutorials and References
In Depth Information
Adding a 3-D Pie Chart to the Workbook
Click New sheet (Move
Chart dialog box) and
then type 3-D Pie
Chart in the ‘New
sheet name’ text box
to enter a sheet tab
name for the chart
Click the OK button
(Move Chart dialog
box) to move the
chart to a new chart
sheet with a new
sheet name, 3-D Pie
Chart in this case
(Figure 3 – 54).
new sheet created
with new name
Figure 3 –54
Other Ways
1. Select range to chart,
press F 11
To Insert a Chart Title and Data Labels
The next step is to insert a chart title and labels that identify the slices. Before you can format a chart item,
such as the chart title or data labels, you must select it. The following steps insert a chart title, remove the legend,
and add data labels.
Chart Tools
Layout tab
Click anywhere in the
chart area outside
the chart to select
the chart.
Labels group
Display the Chart Tools
Layout tab and then
click the Chart Title
button (Chart Tools
Layout tab | Labels
group) to display the
Chart Title gallery.
chart title
Click the Centered
Overlay Title
command in the Chart
Title gallery to add a
chart title centered on
top of the chart.
Select the text in the
chart title and then
type Six-Month
Projection to
add a new chart title
(Figure 3 – 55).
Figure 3 –55
Search JabSto ::

Custom Search