Microsoft Office Tutorials and References
In Depth Information
Adding a Clustered Cylinder Chart to the Worksheet
used in the i nancial industry to show stock market data. A surface chart compares data from
three columns and/or rows in a three-dimensional manner. A doughnut chart is much like a
pie chart, but a doughnut chart allows for comparing more than one set of data, resulting in
a chart that looks like a doughnut, with each subsquent set of data surrounding the previous
set. A bubble chart is much like an X Y (scatter) chart, but a third set of data results indicates
how large each individual dot, or bubble, is on the chart. A radar chart can compare several
sets of data in a manner that resembles a radar screen, with each set of data represented by
a different color. A column or cylinder chart is a good way to compare values side by side.
A Clustered Cylinder chart can go even further in comparing values across categories.
Cell Values and
When you change a cell
value on which a chart is
dependent, Excel redraws
the chart instantaneously,
recalculation is disabled.
If automatic recalculation
is disabled, then you must
press the F9 key to redraw
the chart. To enable
or disable automatic
recalculation, click the
button (Formulas tab |
Establish where to position and how to format the chart.
When possible, try to position charts so that both the data and chart appear on the
screen on the worksheet together and so that the data and chart can be printed in the
most readable manner possible.
When choosing/selecting colors for a chart, consider the color scheme of the rest of the
worksheet. The chart should not present colors that are in stark contrast to the rest of
the worksheet. If the chart will be printed in color, minimize the amount of dark colors
on the chart so that the chart both prints quickly and conserves ink.
In the case of the Save Sable River Foundation Lifetime Fundraising Summary,
comparisons of fundraising activities within each city can be made side by side with
a Clustered Cylinder chart. The chart uses differently colored cylinders to represent
amounts raised for different fundraising activities. Each city uses the same color scheme
for identifying fundraising activities, which allows for easy identii cation and comparison.
For the city of Allentown, for example, the dark blue cylinder representing Corporate
donations shows lifetime donations of $74,029.35
For Chamber City, the maroon cylinder representing Direct Mail donations shows
lifetime donations of $83,867.23
For the city of Pattonsville, the lime green cylinder representing donations for Fun
Runs shows lifetime donations of $64,581.66
For Sable Village, the purple cylinder representing Government donations shows
lifetime donations of $36,387.09
For the city of Strongville, the light blue cylinder representing Phone-a-thon
donations shows lifetime donations of $12,305.85
Because the same color scheme is used in each city to represent the i ve fundraising
activities, you easily can compare funds raised by each fundraising activity among the cit-
ies. The totals from the worksheet are not represented, because the totals are not in the
range specii ed for charting.
Excel derives the chart scale based on the values in the worksheet and then displays
the scale along the vertical axis (also called the y-axis or value axis ) of the chart. For
example, no value in the range B4:G8 is less than 0 or greater than $100,000.00, so the
scale ranges from 0 to $100,000.00. Excel also determines the $10,000.00 increments of
the scale automatically. For the numbers along the y-axis, Excel uses a format that includes
representing the 0 value with a dash (Figure 1– 53).