Microsoft Office Tutorials and References
In Depth Information
Adding a 3-D Pie Chart to the Workbook
Selecting Nonadjacent
Ranges
One of the more difi cult
tasks to learn is selecting
nonadjacent ranges. To
complete this task, do
not hold down the CTRL
key when you select the
i rst range because Excel
will consider the current
active cell to be the i rst
selection, and you may not
want the current active
cell in the selection. Once
the i rst range is selected,
hold down the CTRL key
and drag through the
nonadjacent ranges. If a
desired range is not visible
in the window, use the
scroll arrows to view the
range. You need not hold
down the CTRL key while
you scroll.
6
Click the Font Color button (Home tab | Font group) to apply the most recently used font
color to the selected range.
7
Click cell D8 to deselect the range A2:B8 and display the What-If Assumptions table, as
shown in Figure 3 – 50.
8
Save the workbook.
What happens when I click the Italic and Underline buttons?
Recall that when you assign the italic font style to a cell, Excel slants the characters slightly
to the right, as shown in cell A1 in Figure 3 – 50. The underline format underlines only the
characters in the cell, rather than the entire cell, as is the case when you assign a cell a
bottom border.
Italic button
Underline button
14-point italic
underlined font
8-point font
Figure 3 –50
Break Point: If you wish to stop working through the chapter at this point, you can quit Excel now and then resume the
project at a later point in time by starting Excel, opening the i le called Modern Music Shops Six-Month Financial Projection,
and continuing to follow the steps from this location forward.
Adding a 3-D Pie Chart to the Workbook
Charts
When you change a
value on which a chart
is dependent, Excel
immediately redraws the
chart based on the new
value. With bar charts,
you can drag the bar in
the chart in one direction
or another to change the
corresponding value in the
worksheet.
The next step in the chapter is to draw the 3-D Pie chart on a separate sheet in the
workbook, as shown in Figure 3 – 51. Use a pie chart to show the relationship or
proportion of parts to a whole. Each slice (or wedge) of the pie shows what percent that
slice contributes to the total (100%).
The 3-D Pie chart in Figure 3 – 51 shows the contribution of each month’s
projected operating income to the six-month projected operating income. The 3-D
Pie chart makes it easy to evaluate the contribution of one month in comparison to the
other months.
 
Search JabSto ::




Custom Search