Microsoft Office Tutorials and References
In Depth Information
Adding a Clustered Cylinder Chart to the Worksheet
Adding a Clustered Cylinder Chart
to the Worksheet
As outlined in the requirements document in Figure 1– 2 on page EX 4, the worksheet
should include a Clustered Cylinder chart to graphically represent the lifetime fundraising
for each fundraising activity in which the organization engages. The Clustered Cylinder
chart shown in Figure 1– 53 is called an embedded chart because it is drawn on the same
worksheet as the data.
columns
developed
from
values in
worksheet
Clustered Cylinder chart
chart scale
along y-axis
each color represents
a row (fundraising
activity) in worksheet
each cluster of cylinders
represents a city
dash represents 0
Figure 1–53
Plan
Ahead
Decide on the type of chart needed.
Excel includes 11 chart types from which you can choose, including column, line, pie, bar,
area, X Y (scatter), stock, surface, doughnut, bubble, and radar. The type of chart you
choose depends on the type of data that you have, how much data you have, and the
message you want to convey.
A line chart often is used to illustrate changes in data over time. Pie charts show the
contribution of each piece of data to the whole, or total, of the data. Area charts, like line
charts, illustrate changes over time, but often are used to compare more than one set of
data and the area under the lines is i lled in with a different color for each set of data. An
X Y (scatter) chart is used much line a line chart, but each piece of data is represented by a
dot and is not connected with a line. A stock chart provides a number of methods commonly
(continued)
 
Search JabSto ::




Custom Search