Microsoft Office Tutorials and References
In Depth Information
These charts from illustrate the
use of a consistent style,
which you might find useful.
Here, charts use minimal
formatting, with only the red
mark and the blue figure
number used to add frosting
to the figures. Both items
could be text boxes.
Excel charts like the top one
typically are difficult to
automate or update easily.
This is because data points
often tend to clump in the
bottom left corner of your
chart area. This causes all
the labels to overlap and
become unreadable.
The bottom figure would be
easier to automate than the
top figure. Put the two labels
in text boxes and position the
labels in the bottom left
corner of the chart. Finally, assign the line colors to the labels in the
text boxes, so that the labels can serve as legends.
Search JabSto ::

Custom Search