The Date field contains dates for the entire year excluding weekends, the Region field contains the region name (Eastern, Southern, or Western), and the Sales field contains the sales amount. The following figure shows part of a table that contains daily sales by region.
Learn how to create a pivot chart in Excel 2013 (Step by Step) A pivot chart example You will create a pivot chart placing the fields in proper areas in the PivotChart Fields task pane and pivot table will be generated automatically.
If your cell pointer is not selecting any cell within a pivot table, Excel will prompt you for the data source and will create a pivot chart and a pivot table skeleton.