Microsoft Office Tutorials and References
In Depth Information
When you complete these
changes, you’ll get an ugly
result that looks something like
this figure. Here, there’s virtually
no room for the plot area
because each set of labels has
a higher priority.
To a large degree, the art of creating mini charts is the art of
managing those chart labels.
How to Manage Legends
As a general rule, chart legends
take up more space than they’re
worth. With mini charts,
therefore, the best choice is to
delete the legends.
Here, for example, we’ve lost
nothing by deleting the legend,
and we’ve gained a significant increase in the size of the plot area.
Chapter 8 explains how to add legends when you need them.
How to Manage the X Axis
Because mini-charts typically contain dates in the X axis, I’ll
concentrate on that issue here. The following section describes
ways to compress numbers in the Y axis. If your chart uses other
data in the X axis, you can adapt the techniques for both axes to
Mini-charts usually display trends. And very frequently for internal
reporting, charts display a one-year trend.