O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

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

Creating a stem and leaf plot

Stem and leaf plots are an invaluable method for charting frequency. While a stem and leaf plot is not a true graph compared to bar graphs, pie charts, and so on, it is still used as a method for graphing/charting the frequency of a data within a population. Financial analysts can use this type of chart to determine inventory levels over a specific date range.

In this recipe, you will learn how to create a stem and leaf plot to chart the number of products sold over the course of several months.

How to do it...

Begin with inventory levels listed in Column A:

How to do it...

We will now need to create the stems. The stems are the first ...

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