Microsoft Office Tutorials and References
In Depth Information
Exhibit 2.7 3-D line chart for products A–E
product E (the rear-most line) in early quarters. As I stated earlier, simple graphs are
often better from a presentation perspective.
2.4.3 Speciﬁc Steps for Creating a Chart
We have seen the results of creating a chart in Exhibits 2.3, 2.4, 2.5, 2.6, and 2.7.
Now let us create a chart, from beginning to end, for Exhibit 2.6, the Line chart
for all products. The process we will use includes the following steps: (1) select a
chart type, (2) identify the data to be charted including the x-axis, and (3) provide
titles for the axes, series, and chart. For step 1, Exhibit 2.8 shows the selection of the
Line chart format within the Charts group of the Insert tab. Note that there are also
custom charts that are available for specialized circumstances. In pre-2007 Excel,
these were a separate category of charts, but in 2007, they have been incorporated
into the Format options.
The next step, selection of the data, has a number of possible options. The option
shown in Exhibit 2.9 is one in which a blank chart type is selected and the chart
is engaged. A right click of the mouse produces a set of options, including Select
Data . The chart type can be selected and the data range copied into the blank chart
(one with a border appearing around the chart as in Exhibit 2.9). By capturing the
data range, including the titles (B1:F9), a series title (A, B, etc.) is automatically
provided. Alternatively, if the data range had been selected prior to selecting the
chart type, the data also would have been automatically captured in the line chart.
Note that the X-axis (horizontal) for Exhibit 2.9 is represented by the quarters
of each of the two years, 1–4 for each year. In order to reﬂect this in the chart, you