O'Reilly logo

Excel® 2007 Charts by John Walkenbach

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 8. Charting Techniques and Tricks

In This Chapter

  • Adding lines and background elements to a chart

  • Working with single-point charts that resemble a thermometer or gauge

  • Using an XY series to simulate an axis

  • Creating specialty charts that make use of a variety of tricks

  • Stacking and overlaying charts

  • Putting more than one chart on a chart sheet

This chapter might best be described as the catch-all chapter. You'll find a wide variety of useful charting examples that incorporate various tricks of the trade. These examples may give you some new ideas and stimulate your imagination.

Many of the examples in this chapter assume that you're familiar with the material presented in previous chapters. In other words, I focus on the general technique and assume that you know the basic procedures.

Adding Lines and Backgrounds to a Chart

The following sections present examples of charts that have been augmented in a number of ways to display various types of lines and background elements. Several of the examples involve tricks that make use of combination charts.

Adding Horizontal Reference Lines to a Chart

Many charts benefit from adding one or more reference lines. Figure 8-1 shows an area chart that depicts a product's defect rate over a 20-day period. This chart displays an additional line. Data points that appear above this line represent an unacceptable level of defects.

This combination chart displays a comparison line.

Figure 8-1. This combination ...

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