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 8

Charts That Show Trending

IN THIS CHAPTER

Bullet Understanding basic trending concepts

Bullet Comparing trends across multiple series

Bullet Emphasizing distinct periods of time in your trends

Bullet Working past other anomalies in trending data

No matter what business you’re in, you can’t escape the tendency to trend. In fact, one of the most common concepts used in dashboards and reports is the concept of trending. A trend is a measure of variance over some defined interval — typically, periods such as days, months, or years.

The reason trending is so popular is that trending provides a rational expectation of what might happen in the future. If I know this book has sold 10,000 copies a month over the last 12 months (I wish), I have a reasonable expectation to believe that sales next month will be around 10,000 copies. In short, trending tells you where you’ve been and where you might be going.

In this chapter, you explore basic trending concepts and some of the advanced techniques you can use to take your trending components beyond simple line charts.

Trending Dos and Don’ts

Building trending ...

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