Catalog   

	< Previous Swipe File  |  Next Swipe File >
	Charley's File #39

Many times, it’s useful in a chart figure to offer comments on the behavior of recent results. This figure shows one way to do that.

Here, each area at the right acts as a legend, as a comment box, and as a data label that shows the most-recent value.

Some of the techniques are smilar to those in Swipe File #35.

In magazines, the labels typically are arranged in the same order as the last values in the chart. If I did that here, for example, the green box would be first and the gold box would be last.

I didn’t take this step because doing so would have made the figure more complex. Besides, Excel legends don’t rearrange themselves as the ending values change, and no one seems to notice.

The Setup for the Legend Boxes

The legend boxes mostly consist of text boxes. But because Excel formulas can’t control the formatting of text boxes, we use three of them per legend, one for the title, one for the data value, and one for the notes.

To see how the text boxes are formatted...

(Continued in the documentation.)

Get this Excel workbook now!

	I'm never satisfied unless you are more than satisfied. So here's my simple "no Small Print" guarantee. Try my swipe file today and put it through the ringer. Use it in your reports and presentations for 12 months. You be the judge. If my workbook doesn't deliver everything I've promised, or if you're unhappy with it for any reason, just let me know and I'll immediately give you your money back. I have no problem making this iron-clad guarantee because I've used Excel from day 1; so I know my techniques work. Fair enough?	Summary   Availability: Guarantee: Licensing: File Format: Credit Cards: Instant download. One-year, unconditional. One work copy plus one personal copy. Classic Excel or New Excel Visa, Mastercard, American Express, Discover, PayPal

Only $12.95 USD		Only $12.95 USD