Microsoft Support Number OR Call Toll-Free @ 1-844-478-2887

Thursday, February 26, 2009

Create a PivotTable or PivotChart report

To create a PivotTable or PivotChart report, you must connect to a data source and enter the report's location.This post provide Microsoft excel support tips to create pivot table.

1. Select a cell in a range of cells, or put the insertion point inside of a Microsoft Office Excel table.

Make sure that the range of cells has column headings.
2. Select the type of report to generate by doing one of the following:
* To create a PivotTable report, on the Insert tab, in the Tables group, click PivotTable, and then click PivotTable.

Excel displays the Create PivotTable dialog box.
* To create a PivotTable and PivotChart report, on the Insert tab, in the Tables group, click PivotTable, and then click PivotChart.

Excel displays the Create PivotTable with PivotChart dialog box.

Select a data source by doing one of the following:

Choose the data that you want to analyze

1. Click Select a table or range.
2. Type the range of cells or table name reference, such as =QuarterlyProfits, in the Table/Range box.

If you selected a cell in a range of cells or if the insertion point was in a table before you started the wizard, Excel displays the range of cells or table name reference in the Table/Range box.

Alternatively, to select a range of cells or table, click Collapse Dialog Button image to temporarily hide the dialog box, select the range on the worksheet, and then press Expand Dialog Button image.

Tip Consider using a table name reference instead of a range of cells, because rows added to a table are automatically included in the PivotTable report when you refresh the data.

Note If the range is in another worksheet in the same workbook or another workbook, type the workbook and worksheet name by using the following syntax: ([workbookname]sheetname!range).
Post a Comment