Microsoft Office Tutorials and References
In Depth Information
Hands On: Creating and Customizing a Chart
You can create a chart with a single keystroke. Select the range to be used in the chart and then press Alt+F1 (for an
embedded chart) or F11 (for a chart on a chart sheet). Excel displays the chart of the selected data, using the default chart
type. The default chart type is a column chart, but you can change it. To change the default chart type, select any chart and
choose Chart Tools ➪ Design ➪ Type Change Chart Type. The Change Chart Type dialog box appears. Choose a chart type
from the list on the left, and then right-click a chart in the row of thumbnails and choose Set As Default Chart.
Hands On: Creating and Customizing a Chart
This section contains a step-by-step example of creating a chart and applying some
customizations. If you’ve never created a chart, this is a good opportunity to get a feel for how the
process works.
Figure 18.4 shows a worksheet with a range of data. This data shows customer survey
results by month, broken down by customers in three age groups. In this case, the data
resides in a table (created by choosing Insert Tables Table), but that’s not a requirement
to create a chart.
FIGURE 18.4
The source data for the hands-on chart example
18
Selecting the data
The fi rst step is to select the data for the chart. Your selection should include such
items as labels and series identifi ers (row and column headings). For this example, select
the entire table (range A4:D10). This range includes the category labels but not the title
(which is in A1).
If you want to chart all data in a table (or a rectangular range separated from other data), you can select just a single
cell. Excel will almost always select he range for the chart accurately. If you don’t want to plot all data in the table,
just select the specii c columns or rows.
 
Search JabSto ::




Custom Search