Microsoft Office Tutorials and References
In Depth Information
Specifying a Date Axis
The Sparkline Tools
Axis command lets you override this automatic
behavior and control the minimum and maximum value for each sparkline or for a group
of sparklines. For even more control, you can use the Custom Value option and specify the
minimum and maximum for the sparkline group.
Sparklines don’t actually display a vertical axis, so you’re essentially adjusting an invisible axis.
Figure 19.32 shows two groups of sparklines. The group at the top uses the default axis
settings (Automatic for Each Sparkline). Each sparkline shows the six-month trend for the
product, but there is no indication of the magnitude of the values.
FIGURE 19.32
The bottom group of sparklines shows the effect of using the same axis minimum and
maximum values for all sparklines in a group.
For the sparkline group at the bottom (which uses the same data), the vertical axis
minimum and maximum was changed to use the Same for All Sparklines setting. With these
settings in effect, the magnitude of the values across the products is apparent — but the
trend across the months within a product is not apparent.
The axis scaling option you choose depends upon what aspect of the data you want to
Specifying a Date Axis
Normally, data displayed in a sparkline is assumed to be at equal intervals. For example,
a sparkline might display a daily account balance, sales by month, or profi ts by year. But
what if the data isn’t at equal intervals?
Figure 19.33 shows data, by date, along with a sparklines graphic created from column B.
Notice that some dates are missing, but the sparkline shows the columns as if the values
were spaced at equal intervals.
Search JabSto ::

Custom Search