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

Visualizing payments with a graphical calendar

Date representation is a difficult task to complete. It is essential to track dates with financial transactions to glean information such as frequency, patterns, customer information, and due dates; however, unlike numbers, dates cannot be easily graphed via Excel.

In this recipe, you will learn to create a worksheet-based calendar to represent the payment dates visually.

How to do it...

We will start with a worksheet with dates and payment amounts:

How to do it...
  1. Select column A, then from the Excel ribbon select Formulas | Define name:

    When the name manager opens, the name should already be set as the column title listed ...

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