Catalog >  

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

This figure uses dynamic chart legends. I had a lot of fun setting it up; I hope you like it!

As you can see in these two examples, the legend automatically adjusts to the current value in the chart.

In the left version, for example, the best-selling product line is Slacks; but in the right version, it’s Shirts. Because the sample data uses random numbers, the legend bar changes each time the workbook recalculates.

I used conditional formatting to create the dynamic legend. That’s a problem if you still use Excel 2003, however, because that version supports only three conditional formats per cell.

(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 $14.95 USD		Only $14.95 USD