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.2–3.4. In section 3.1 we give a presentation of some of the different charts and graphs Excel offers.
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. ...