I do not have 2013 booted up right now but I do not believe there is an option for Pivot Tables anymore.
https://support.office.com/en-za/art...d-9a2dfef68e2f
It seems you still have the option for charts. I have automated excel to place a graphic that was exported from Access.
I think this is working code. It only demonstrates part of what is needed for multiple charts.
Code:
Dim xlApp As Excel.Application
Dim myBook As Workbook
Dim mySheet As Worksheet
Dim myChart As ChartObject
Set xlApp = CreateObject("Excel.Application")
Set myBook = xlApp.Workbooks.Open("C:\Test\" & "TestChart.xlsx")
Set mySheet = myBook.Sheets.Item(1) 'Grab the first worksheet
xlApp.Visible = False
For Each myChart In mySheet.ChartObjects
myChart.Activate
With xlApp.ActiveChart
.Export ("C:\Test\" & "TestChart_" & myChart.Index & ".bmp")
End With
Next 'Iterate all chart objects in mySheet
myBook.Close
xlApp.Quit
Set myBook = Nothing
Set mySheet = Nothing
Set myChart = Nothing
Set xlApp = Nothing
If you need a really complex chart or a pivot chart (I think that is what the pivot thing is called in excel) you will have to automate excel and feed data to it.