Chapter 9. Dynamic Chart Formatting and Other Tricks
In Microsoft Excel, there are integrated formats, user-defined formats, and conditional formats. Your Excel may also include what I call “dynamic chart formats.” In addition to reading changing content via controls, as already seen, you can also base the formal design of specific chart elements on changing content. This is mostly what I’ll discuss in this chapter.
Minor examples were already introduced in Chapter 8: There I introduced the “cheating” concept (legitimately and only in the interest of the target group): using hidden data and formulas with elements that are only sometimes visible is one of the most effective options in Excel’s bag of tricks.
The files for this chapter that are available ...
Get Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
