Microsoft Office Tutorials and References
In Depth Information
‘Position the PivotChart so its top left corner
‘occupies cell H23, a few rows below the PivotTable.
ActiveChart.Parent.Left = Range(“H23”).Left
ActiveChart.Parent.Top = Range(“H23”).Top
‘Deselect the PivotChart.
‘Turn on ScreenUpdating.
Application.ScreenUpdating = True
Press Alt+Q to return to your worksheet and test your macro. Figure 15-23 shows what the
worksheet should look like with the PivotChart added right where it was specified in VBA.