Next, in the Create PivotChart window, the table name (WorkOrders) should automatically appear in the Table/Range box.On the Excel Ribbon, click the Insert tab.
Select any cell in the work orders table.In this example, there is a named Excel table with 2 years of data from service calls at a manufacturing company.įrom this data source, we want compare the number of service call work orders completed each month, year over year.Ī pivot table will summarize the work order data, and a pivot chart will show a visual summary.įollow these steps to create the pivot table and pivot chart, both at the same time.
0 kommentar(er)
