Access 2013 - Bar charts and pivot charts solution

[djspod]

Hi ,

What's the best work around solution to display Graphs and pivot chart data from my tables in Access 2013?



I heard that you now have to go outside the program via excel (Exporting Data)

Thanks

[ItsMe]

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.

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.

[djspod]

Thanks for help and information.

I will give that a try and feedback.

Thanks