3  Charts and tables

Excel is an excellent tool for generating different kinds of tables and charts. In terms of tables, Excel offers three different kinds which are Excel tables, Pivot tables and Data tables. We take a closer look at these in sections 3.23.4. In section 3.1 we give a presentation of some of the different charts and graphs Excel offers.

3.1 Charts

Excel includes a module for drawing charts. We can choose between different graphs and charts in the group Charts under the tab Insert as illustrated in figure 3.1. The most commonly used are Column, Line and Scatter.

A column chart can for instance be used to display the rain for months through a year. Then the height of the columns will indicate the amount of rain in different months. ...

Get Financial Modelling and Asset Valuation with Excel now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.