Hi

When you use the F11 key to create a chart, the PT has already been created
and you have chosen which fields are to be Page, Row or Column Fields, and
which fields represent the data.
As none of those are set before the Pivot table is created, it would not be
possible to have an icon or a shortcut key which achieves what you want.

In Excel 2003 and lower, you can just place your cursor in cell
A1DataPivot TableFinish and this will get you to the skeleton PT on a new
sheet ready to allocate the fields.

If you wanted that as a macro, to add to an icon on your toolbar it would be
something like

Sub CreatePivot()
Range("A1").Select
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _
"Sheet1!R1C1:R3C3").CreatePivotTable TableDestination:="",
TableName:= _
"PivotTable1", DefaultVersion:=xlPivotTableVersion10
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select

End Sub

To use the macro, copy the above
Alt+F11 to invoke the VB Editor
InsertModule
Paste code into white pane that appears
Alt+F11 to go back to Excel

Alt+F8 (or ToolsMacros) select CreatePivotRun

Or, allocate the macro to an icon added to your Toolbar.

--
Regards
Roger Govier

"Raja" wrote in message
...
Is there a shortcut key assigned to creating a pivot table?

Example the chart can be created by selecting the data and pressing F11
key
which takes all the default settings and creates a new column chart in a
new
sheet!!

Is there a simply key combination for creating a Pivot Table? any other
helpful tip or trick related to Pivot tables will be highly appreciated!!

Cheers

Raja