I am using this code to create an embeded chart from pivot table.
Dim pt As PivotTable
Dim myChartObject As ChartObject
Sheets("AOSTESUMMARY").Select
Set pt = Sheets("AOSTESUMMARY").PivotTables(1)
pt.TableRange1.Select
Worksheets("AOSTESUMMARY").ChartObjects.Add Left:=500, Top:=500, Width:=300, Height:=300
However charts is created at unspecific location.
say I want to create chart at cell "C1"..
what should be my code?
Dim pt As PivotTable
Dim myChartObject As ChartObject
Sheets("AOSTESUMMARY").Select
Set pt = Sheets("AOSTESUMMARY").PivotTables(1)
pt.TableRange1.Select
Worksheets("AOSTESUMMARY").ChartObjects.Add Left:=500, Top:=500, Width:=300, Height:=300
However charts is created at unspecific location.
say I want to create chart at cell "C1"..
what should be my code?