How to Make Charts and Tables for an Excel Report ... the first field you select will be the reference field. In this example, this pivot table will show website traffic information by month.

32 students were asked which season was their favourite. The table shows the results. Construct a bar chart that represents these results. Image caption, To construct a bar chart first identify ...