Results 1 to 3 of 3
  1. #1
    templeowls is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    305

    Better to generate charts/graphs through Access or Excel?


    Looking for some advice prior starting any changes. I have a massive database with Customer complaints, injuries, etc. Pretty simplistic and includes incident location. I generate reports monthly that go to each location's manager. It's really just two graphs. Incident totals by month (bar graph) and a types of incidents (pie chart). I currently do it in excel. I have the database linked, which then flows into pivot tables, ands then flows into charts. I then export those charts into Powerpoint. It's time-consuming though because we have roughly 30 locations and copy / pasting these 60~ charts into 30 powerpoint files takes some time.

    Utilizing Reports within Access, is this something that could be automated? Like having 30 different reports on the database that are just updating regularly? Any thoughts are helpful. Thank you!

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    it is something that can be automated, but I would say excel charts have the edge in terms of flexibility of design. But if yours are pretty straightforward, they can be incorporated into reports.

    However if it ain't broke - have you not considered using vba in excel to export the graphs into a powerpoint file? the code would be similar. Here are some links as an example
    https://www.extendoffice.com/documen...owerpoint.html
    https://smallbusiness.chron.com/copy...vba-40834.html

    edit - you wouldn't have 30 different reports in access, you would have one - and have a parameter to specify the location then the routine is

    select parameters (location/dates/whatever), these may be in a table, hardcoded in vba or calculated in some way
    open report
    export report
    close report
    repeat for next parameters

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Although cheating in Excel is more powerful, personally I do almost all my charts in Access as its good enough for almost all chart types I ever use.
    As you mentioned bar charts related to incidents, you may be interested in a different way of doing this in the attached example Incident Analysis app
    For more info see the second part of this link http://www.mendipdatasystems.co.uk/m...lter/459445429
    Attached Files Attached Files
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 01-16-2020, 04:08 AM
  2. ACCESS AUTO generate charts
    By zubair136 in forum Access
    Replies: 3
    Last Post: 07-27-2019, 01:41 PM
  3. VBA in Access or Export to Excel for Graphs
    By octsim in forum Programming
    Replies: 5
    Last Post: 11-04-2013, 10:56 AM
  4. Graphs/Charts
    By alliandrina in forum Access
    Replies: 3
    Last Post: 05-09-2011, 03:08 PM
  5. Working with OLE excel charts in Access 2010
    By snoopy2003 in forum Programming
    Replies: 1
    Last Post: 02-23-2011, 12:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums