Microsoft Office Tutorials and References
In Depth Information
Working with Chart Data
TABLE 12.1 (continued)
A special type of chart that is used to show stock prices.
A 3-D sheet that is used to illustrate the highest and lowest
points of the data set.
Shows changes of data frequency in relation to a center point.
At any point, you can return to your PowerPoint presentation by clicking anywhere outside of the chart on the slide. To
edit the chart again, you can click the chart to redisplay the chart-specii c tabs.
If you delete a column or row by selecting individual cells and pressing Delete to clear them, the empty space that these cells
occupied remains in the chart. To completely remove a row or column from the data range, select the row or column by clicking its
header (letter for column; number for row) and click Delete on the Home tab in Excel.
Working with Chart Data
After you create a chart, you might want to change the data range on which it is based or
how this data is plotted. The following sections explain how you can do this.
Plotting by Rows versus by Columns
By default, the columns of the datasheet form the data series. However, if you want, you
can switch the data around so that the rows form the series. Figure 12.5 and Figure 12.6
show the same chart plotted both ways so that you can see the difference. (The data for
this chart appears in the next section of the chapter, in Figure 12.7, in case you want to
reference it.)
What does the term data series mean? Take a look at Figure 12.5 and Figure 12.6. Notice
that there is a legend next to each chart that shows what each color (or shade of gray) rep-
resents. Each of these colors, and the label associated with it, is a series. The other variable
(the one that is not the series) is plotted on the chart’s horizontal axis.
Search JabSto ::

Custom Search