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

Adding mini graphs within the data

Similar to the repetition analysis shown earlier in this chapter, visual representation is important to making decisions. However, having the data along with a representation allows for a more complete view of the information, and allows for a more complete decision.

In this recipe, you will learn how to add mini-graph elements to your data to enhance analysis. Although this recipe will utilize a graph element from Excel, the graph is provided in-line to the text, which qualifies this as a non-standard visual element.

How to do it...

Begin with the data you wish to interpret. In this recipe, we will use a budget sheet for D-Best Financial:

  1. Lay out your Excel chart as shown in the following screenshot:
  2. Select cell ...

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