Microsoft Office Tutorials and References
In Depth Information
Adding Sparklines and Data Bars
Figure 4-35
Rotated 3-D pie chart
The horizontal and vertical rotation has a signifi cant impact on the way the chart
looks. The pie chart was rotated clockwise one-quarter of the way around the circle so
that the largest slice, the red U.S Stocks slice, is in the front. The vertical rotation turned
the pie chart so that the viewer is looking down on the chart at a lower angle above the
horizontal axis. Ajita is pleased with the 3-D effect you added.
Creating Effective 3-D Charts
Although 3-D charts are visually attractive, they can obscure the relationship between
the values in the chart. This is especially true when an exaggerated perspective obscures
the relative sizes of different chart elements, such as pie slices.
Because of the visual distortion that can result with 3-D representations, you should
include data labels with all 3-D charts. Also, try to avoid extreme viewing angles that
elongate chart elements and might cause the viewer to misread the data. Although
3-D charts can be eye-catching, do not use this effect if it overrides the main purpose of
a chart, which is data interpretation.
Adding Sparklines and Data Bars
For more compact graphing, you can insert charts within worksheet cells. Excel provides
two tools to do this—sparklines and data bars. Both convey graphical information about
worksheet data without occupying a lot of space.
Creating Sparklines
A sparkline is a mini chart that is displayed within a worksheet cell. Because sparklines
are compact in size, they don’t include chart elements such as legends, titles, gridlines,
or axes. The goal of a sparkline is to convey the maximum amount of graphical
information within a very small space. As a result, sparklines are useful when you don’t want
charts to overwhelm the rest of your worksheet or take up valuable page space.
Search JabSto ::




Custom Search