O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required