Microsoft Office Tutorials and References
In Depth Information
Creating a Basic Chart
Creating a Basic Chart
Excel provides two methods for
putting your data into a chart. The first
method, which is the really quick way,
involves telling Excel where your data is located
and pressing a single key on the keyboard. Excel
creates a chart that you can then edit or move.
Take a look at the first method and the
components of a chart.
Don’t Include Totals
Typically, if you are selecting values such as
monthly figures, you don’t want to include
totals in your chart.
Second, press the F11 key. Excel immediately adds
a new sheet called Chart1 to your workbook with
the data plotted into a column chart. Each
subsequent chart page is numbered sequentially such as
Chart2, Chart3, and so forth.
Editing the Chart
Throughout this chapter you learn how to
edit the look and style of a chart.
Different Keyboards
The steps are very simple. First, select the data
(sequential or nonsequential) you want to plot in
the chart. See Figure 13-1, in which cells A2
through D6 are selected as an example of
sequential data for a chart.
Some newer keyboards use a different
function for the F11 key. If your F11 key does not
produce a chart, use the Insert tab as
explained in the next section.
To modify the chart, you first need to know the
various components involved in a chart. Figure
13-2 shows you the various components that can
make up a chart, and Table 13-1 identifies each of
those components.
Figure 13-1
Selecting your chart data.
Search JabSto ::




Custom Search