Microsoft Office Tutorials and References
In Depth Information
Providing the Raw Data for Your Chart
Table 1-1 (continued )
Symbol
Chart
Type
Best Use/Description
Column
Compare values in different categories against one
another, usually over time. Data is displayed in vertical
columns. (Same as a bar chart except that the bars are
vertical.)
Combo
Contrast two sets of data, with one chart overlying the
other to draw out the contrast. Data is displayed in
lines, bars, and stacks.
Line
Examine how values fluctuate over time. Data is
displayed in a set of points connected by a line.
Pie
See how values compare as percentages of a whole.
Data from categories is displayed as a percentage of a
whole. (Similar to a doughnut chart.)
Radar
Examine data as it relates to one central point. Data
is plotted on radial points from the central point. This
kind of chart is used to make subjective performance
analyses.
Stock
See how the value of an item fluctuates as well as its
daily, weekly, or yearly high, low, and closing price.
This chart is used to track stock prices, but it can also
be used to track air temperature and other variable
quantities.
Surface
Examine color-coded data on a 3D surface to explore
relationships between data values.
XY
(Scatter)
Compare different numeric data point sets in space to
reveal patterns and trends in data. (Similar to a bubble
chart except that the data appears as points instead of
bubbles.)
Providing the Raw Data for Your Chart
Every chart is constructed from raw data — the numbers and labels you
select in an Excel worksheet (in Excel) or enter in the data grid (in Word and
PowerPoint). If you’re operating in Word or PowerPoint, you see, in the data
grid, sample data in a data range , as shown in Figure 1-2 . The information
inside the data range is used to generate the chart. You can tell where the
data range begins and ends because it is enclosed in a blue border. Your job
is to replace the sample data in the data range with data of your own. As you
enter your data, the chart on your slide or page takes shape.
Search JabSto ::




Custom Search