
To learn how, see “Formatting Charts” on page 141 and “Changing a Chart from One
Type to Another” on page 140.
Changing a Chart from One Type to Another
You can change a chart’s type anytime you like. Some chart types, however, use the
row and column data dierently, as described below.
To change a chart from one type to another:
1 Select the chart.
2 Click Inspector in the toolbar, click the Chart inspector button, and then choose a
dierent chart type from the pop-up menu that appears when you click the chart icon
in the upper left.
If you switch to a pie chart, the rst data point in each series is represented as a wedge.
If you switch to a scatter chart, each point in the chart requires two values. If the chart
is based on an odd number of rows or columns, the last row or column isn’t plotted.
If you switch to a bar, column, area, or line chart, each series in the new chart
corresponds to a row or column in the Chart Data Editor.
If you switch to a 3D version of a chart, the Chart inspector provides controls for
managing object depth, lighting style, and more.
Formatting you’ve applied to the chart you’re changing may not be applied to the new
chart. For example, the color ll attribute of data point elements (bars, wedges, and so
on) has a dierent default value for each type of chart. If you’ve changed a column ll
color and then change the chart to be a bar chart, the ll color change isn’t retained.
Depending on the type of chart, the attributes that may revert to the default styling
are value labels and position, text style, series stroke, series shadow, series ll, data
point symbols, and data point lls.
When you change a chart’s type and the new type has some of the same attributes,
those attributes don’t change. Shared attributes include axes, gridlines, tick marks,
axis labels, show minimum value, number format, borders, rotation, shadows, and 3D
lighting style. See “Formatting Charts” on page 141 for more information.
Bar or column charts, and stacked bar or column charts, share attributes except for
value label position. Also, bar and column charts have separate lls.
3D chart shadows are shared across chart types.
Editing Data in an Existing Chart
To edit the data in an existing chart, you must rst open the Chart Data Editor and
then enter your new data. As you edit the data, the chart is immediately updated to
reect the new data.
140 Chapter 9 Creating Charts from Data
Comentarios a estos manuales