Write a VBA macro for Excel that creates one or more Pivot Tables and a Pivot Chart from an existing named Table (ListObject) on a specific worksheet. Follow these conventions exactly:
Setup:

Use Dim declarations for all objects at the top (worksheets, pivot cache, pivot tables, chart object, list object)
Reference the source table by both worksheet name and ListObject name
Delete and recreate the output sheet (suppress alerts with Application.DisplayAlerts = False, use On Error Resume Next for the delete, then reset to On Error GoTo 0)
Add the new sheet with Worksheets.Add(Before:=wsData) and assign a name

Pivot Cache:

Create one shared PivotCache using xlDatabase and the ListObject as SourceData

Pivot Tables (create as many as needed):

Place each table at a specific named range (e.g. "A3", "E3")
Give each table a unique TableName
Set row fields using .PivotFields("FieldName").Orientation = xlRowField and .Position
Add value fields using .AddDataField with a custom display name and aggregation (e.g. xlSum)
Apply NumberFormat like "#,##0" to value fields
Optionally apply .AutoSort xlDescending on a row field
Apply a table style using .TableStyle2 = "PivotStyleMedium9"

Pivot Chart:

Add a ChartObject anchored to a named range cell (use .Left and .Top of the cell)
Set width 480, height 300
Set ChartType = xlColumnClustered
Add a bold, 14pt Calibri chart title
Apply Calibri font to the entire ChartArea via Format.TextFrame2.TextRange.Font.Name
Remove the legend (HasLegend = False)
Apply data labels to the first series with "#,##0" format, Calibri 9pt
Format both xlCategory and xlValue axes: Calibri 9pt tick labels, remove all major and minor gridlines
Hide all pivot chart field buttons: .ShowAllFieldButtons = False

End:

Activate the output sheet and select "A1"

My specifics:

Source sheet name: [YOUR SHEET NAME]
Source table name: [YOUR TABLE NAME]
Output sheet name: [YOUR OUTPUT SHEET NAME]
Pivot Table 1: Row field = [FIELD], Value field = [FIELD], sort descending by value
Pivot Table 2 (for chart): Row field = [FIELD], Value field = [FIELD], no sort
Chart title: "[YOUR TITLE]"