O'Reilly logo

Excel® Dashboards & Reports by John Walkenbach, Michael Alexander

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 13. Components that Show Performance against a Target

In This Chapter

  • Using variance to compare performance with a target

  • Displaying performance against organizational trends

  • Creating a Thermometer-style chart

  • Creating a bullet graph

  • Showing performance against a target range

No matter what business or industry you talk about, you can always point to some sort of target to measure data against. That target could be anything from a certain amount of revenue to the number of boxes shipped or phone calls made. The business world is full of targets and goals. Your job is to find effective ways to represent performance against those targets.

What is performance against a target? Imagine your goal is to break the land speed record (currently 763 miles per hour). Your target speed is 764 miles per hour. After you jump into your car and go as fast as you can, you will have a final speed of some number. That number is considered to be your performance against the target.

In this chapter, we discuss some new and interesting ways to create components that show performance against a target.

Showing Performance with Variances

The standard way of displaying performance against a target is to plot the target and then plot the performance. This is usually done with a line chart or a combination chart, such as the one shown in Figure 13-1.

A typical chart showing performance against a target.

Figure 13-1. A typical chart showing performance against a target. ...

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