Microsoft Office Tutorials and References
In Depth Information
Working with Sparklines
Deleting a Chart
If you create a chart and then decide you don’t
want it, you can easily delete it. Deleting a chart
does not delete any data, only the chart compiled
from the data. If the chart is an object on the data
page, select the chart and press the Delete key. If
the chart is on its own sheet, right-click the chart
sheet tab and choose Delete. Click Delete at the
confirmation message that appears.
Figure 13-29
Liven up your charts with graphic images.
Working with Sparklines
New to Excel 2010 are sparklines ,
which are tiny charts that fit into a single
cell, typically located near your data. The
concept, originally created by Edward Tufte, is
often called “intense word-sized graphics”.
Earlier in this chapter, you discovered how you can
create some incredible Excel charts based on your
data. Standard Excel charts however, are typically
large in size and are separate from the data on
which they are based.
Figure 13-30 shows an example of some raw data
in an Excel spreadsheet. This data represents sales
by color over a 12 month period. If you need to
quickly determine sales trend, you’d have to do a
lot of calculating.
A sparkline chart provides a quick visual
representation of the data showing, at a glance, trends such as
the effect of your advertising or whether your sales
are growing, stagnant or falling. Sparklines not only
make sense as a powerful means to increase the
analytical depth of your numbers, they can also add
information where space is scarce.
Search JabSto ::




Custom Search