Microsoft Office Tutorials and References
In Depth Information
Creating a new chart
If you want your chart to focus on particular rows of data within a large block, a
table can make that process more convenient. When you convert a range to a table,
Excel adds filter controls to each column in the range. You can use these controls to
hide the rows in which you’re not currently interested. For example, you can set up a
chart that plots the most recent month’s numbers in a table of time-related data or
the rows that have the top 10 values in some column of interest. Note, however, that
when you change or remove the filter, Excel adjusts the chart so that it plots the
visible rows. To make a permanent plot of particular rows in a range, select those rows
explicitly without filtering the range. (You can plot noncontiguous rows by holding
down Ctrl while you select each one.)
If you want your source data and chart to have consistent or complementary
formatting characteristics, you can achieve that more easily using table styles and chart
For information about tables, see Chapter 22, “Managing information in tables.” For
information about chart styles, see “Choosing a chart style” later in this chapter.
Creating a new chart
When you have selected the data you want to chart, click the Insert tab. The Charts group
on the ribbon appears in the center of the ribbon, presenting you with an assortment of
chart-type buttons. You can go straight to the options for creating a particular kind of chart
by clicking that chart-type button. For example, if you know you want a column chart, you
can click the Column Chart button to see a set of options related to that chart type:
The gallery that unfolds presents a set of subtype options—various kinds of stacked and
unstacked two-dimensional column charts, for example, as well as a selection of
threedimensional possibilities—and you can see still more choices by clicking the More… button
at the bottom of the gallery.
Search JabSto ::

Custom Search