Microsoft Office Tutorials and References
In Depth Information
Appendix: Generating Charts in Excel 2003 and Mac Excel 2011
FIGURE 6.36 Selecting a Series or a Data Point
FIGURE 6.37 Data Series versus Data Point Formatting
Alternatively, it is possible (after data selection) to use the mouse and drag the
data into the chart. The data will be added to the chart.
All charts in Excel have some common characteristics. All data series (in our
example, the sets of columns) can be marked the same way. If you click on a column
once, all the columns in the series will be marked. For example, all of the sales will be
marked if you click one of the sales columns. If you click on the same column a
second time, it only marks that individual column.
Use the rule: First click marks all of the points (columns) in a series
click marks the individual point (or a single column).
See Figure 6.36. Marking a series this way (first click for all the points and
second click for the individual column) works in all charts in Excel.
If you right-click after all of the points are marked, you can format the entire
series (in the local menu use Format Data Series). If an individual column is marked
(second click) you can format the individual column by itself (in the local menu use
Format Data Point). See Figure 6.37.
More about the Chart Wizard The Chart Wizard can be used for a variety of charts.
This section illustrates a few of these options.
Column and Pie Using the same data, we will create a
three-dimensional column chart and a pie chart. A 3-D column chart is shown in
This chart is called
You may go
back to the text in this chapter to find out how to paste pictures into the chart.
Clustered column with a 3-D visual effect.
Pie Charts To create a simple pie chart, select the data and continue with the Chart
Wizard steps as shown in Figure 6.39.