Microsoft Office Tutorials and References
In Depth Information
Embedded and Standalone Charts
Charting 101
asking it to chart.) After setting the vertical scale, Excel adds the labels along the
bottom axis (also known as the X-axis or category axis), and draws the columns of
appropriate height.
Embedded and Standalone Charts
The chart in Figure 19-1 is an embedded chart. Embedded charts appear in a
worksheet, in a floating box alongside your data. You can move the chart by dragging
the box around your worksheet, although depending on where you put it, you may
obscure some of your data.
Your other option is to create a standalone chart, which looks the same but occupies
an entire worksheet. That means that your chart data and your chart are placed on
separate worksheets.
Usually, you’ll use an embedded chart if you want to create printouts that combine
both your worksheet data and one or more charts. On the other hand, if you want
to print the charts separately, it’s more convenient to use standalone charts. That
way, you can print an entire workbook at once and have the charts and the data on
separate pages.
Note: If you use embedded charts, you still have the option of printing just the chart, sized so that it fills
a full sheet of paper. Simply select the chart, and then choose File➝Print. If you create a standalone chart,
you don’t have a choice—Excel always prints your chart on a separate page.
Creating a Chart with the Ribbon
So how do you create a chart like the one shown in Figure 19-1? Easy—all it takes is
a couple of clicks in the ribbon. Here’s how it works:
1. Selecttherangeofcellsthatincludesthedatayouwanttochart,includingthe
If you were using the data shown in Figure 19-1, you’d select cells A1 to B7.
For speedier chart building, just position your cursor somewhere inside the
data you want to chart. Excel then automatically selects the range of cells that it
thinks you want. Of course, it never hurts to remove the possibility for error by
explicitly selecting what you want to use before you get started.
2. Headtotheribbon’sInsert Chartssection.You’llseeaseparatebuttonfor
each type of chart (including column charts, line charts,pie charts, and so
When you choose a chart type, you get a drop-down list of subtypes
(Figure 19-2).
Search JabSto ::

Custom Search