Skip to Main Content
Excel Dashboards & Reports For Dummies, 4th Edition
book

Excel Dashboards & Reports For Dummies, 4th Edition

by Michael Alexander
April 2022
Beginner to intermediate content levelBeginner to intermediate
384 pages
9h 47m
English
For Dummies
Content preview from Excel Dashboards & Reports For Dummies, 4th Edition

Chapter 10

Displaying Performance against a Target

IN THIS CHAPTER

Bullet Using variance displays

Bullet Using progress bars

Bullet Creating bullet graphs

Bullet Showing performance against a range

Hopefully, this is an easy one to grasp. Someone sets a target, and someone else tries to reach that target. The target can be anything from a certain amount of revenue to a number of boxes shipped or to 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 do I mean by performance against a target? Imagine that your goal is to break the land speed record, which is now 763 miles per hour. That makes the target 764 miles per hour, which will break the record. After you jump into your car and go as fast as you can, you will have a final speed. That number is your performance against the target.

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

Showing Performance with Variances

The standard way to display performance against a target is to plot the ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Dashboards and Reports for Dummies, 3rd Edition

Excel Dashboards and Reports for Dummies, 3rd Edition

Michael Alexander

Publisher Resources

ISBN: 9781119844396Purchase Link