Chapter 27. Advanced Charting Techniques
In this chapter, you explore assorted topics that don't fall neatly into the preceding three chapters. You look at a couple of Excel's more exotic chart types, consider the use of Excel for creating Gannt charts, and learn ways to make Excel perform some formatting feats that it would rather not. Let's begin with a technique for making your charts stay current as you add to their source data.
Using Named Ranges to Create Dynamic Charts
If you select a chart's series and look at Excel's formula line, you see that a series is generated by a formula ...
Get Microsoft® Office Excel 2003 Inside Out 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.
