Page 124 - Excel Data Analysis
P. 124
07 537547 Ch06.qxd 3/4/03 12:09 PM Page 110
EXCEL DATA ANALYSIS
MODIFY A CHART TYPE
o emphasize a different aspect of your data You use the Chart menu, which appears when you
or to apply a different type of comparison, select a chart and you have the Data menu open, to
T you can change your chart type. See the make modifications to an existing chart. Depending
section "Chart Basics" for more information on upon the current chart type, some menu options may
the available chart types.
appear grayed out. For example, the 3D View option
You change the chart type for any chart in a becomes available only when you select a 3D chart.
workbook using the Chart Type option. The only
thing you need to keep in mind is that some chart If you have an embedded chart in a worksheet, the
types require specific types of data. For example, if Chart menu displays when you have any portion of
you convert an exploded pie chart to a column the chart object selected. If your worksheet contains
chart, the individual data will not be emphasized. multiple chart objects, the changes made from the
Chart menu only affect the selected chart.
When you switch to a different chart type, by
default, Excel maintains any special formatting from When you select a Chart Sheet, the Chart menu
the existing chart. For example, if you have always displays in the Menu bar. Any changes made
modified font types or colors, those options apply from the Chart menu affect the chart on the Chart
to the new chart type. If you want to use the default Sheet.
formatting of the new chart type, you must select
the Default formatting option.
MODIFY A CHART TYPE
Column
⁄ Click anywhere on the ■ For a chart sheet, click the ■ The Chart Type dialog box ˇ Click the option for
chart object to select an tab of the chart you want to displays. Default formatting to replace
embedded chart. modify. custom formatting.
‹ Click the desired chart
¤ Click Chart ➪ Chart Type. type. Á Click OK.
› Click the appropriate ■ The selected chart updates
chart sub-type. to the new chart type.
110
