To create a chart in an Excel report sheet: Select Insert from the ... the first field you select will be the reference field. In this example, this pivot table will show website traffic ...