Results 1 to 4 of 4
  1. #1
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102

    Export a bunch of graphs to Excel. Or copy paste multiples at once.

    If I have the graph enabled in a form, it can be copy-pasted to Excel... but it's not possible to select multiples at once, and there are a lot of graphs.



    Is there some command to copy a whole bunch and then the user can paste them all into an Excel sheet?
    Or some command to export all at once?

    THIS ISN'T IMPORTANT, BUT IT'D BE GREAT
    On a side note, the reports aren't really necessary (Supervisor doesn't want PDFs, but reports don't export graphs into Excel, so...), but I kinda want them to update when new data is entered. I read something about a "Requery" command, as well as this: https://forum.openoffice.org/en/foru...p?f=42&t=26625... but ehm... I don't fully get it, not quite sure where the options they're talking about are.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    So why not just export the data, and let excel show the graphs?

  3. #3
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102
    Quote Originally Posted by ranman256 View Post
    So why not just export the data, and let excel show the graphs?
    If you're talking about exporting the raw data, and having Excel calculate the graphs, that's already a thing that happens. I got the raw data from a system like that. HOWEVER:
    The graphs are going to be put in a PowerPoint presentation. That's it. For a full explanation of that Excel sheet I took the data from: https://www.accessforums.net/showthread.php?t=71754
    Basically, we want nothing else to do with that Excel system. Also, I'm kind of afraid to export that much data (a month has on avg. 500 incidents) into a sheet in that Excel file, feels like I'm going to break it.

    As I'm writing this, I realize that maybe the reports in fact would be better. To keep track of previous months. While the user could just copy from the forms the specific graphs necessary for the presentation.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Googgle: PowerPoint graph link Access
    Review https://msdn.microsoft.com/en-us/lib...ffice.11).aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Excel object, copy and paste a worksheet
    By crowegreg in forum Programming
    Replies: 2
    Last Post: 05-28-2014, 12:04 PM
  2. VBA in Access or Export to Excel for Graphs
    By octsim in forum Programming
    Replies: 5
    Last Post: 11-04-2013, 10:56 AM
  3. How to copy and paste between worksheets in Excel?
    By Ronald Mcdonald in forum Programming
    Replies: 6
    Last Post: 05-26-2012, 10:40 PM
  4. Copy and Paste Format From Excel (attached)
    By KrenzyRyan in forum Import/Export Data
    Replies: 2
    Last Post: 01-02-2012, 05:56 PM
  5. COPY records from SUBFORM and PASTE to EXCEL?
    By taimysho0 in forum Programming
    Replies: 9
    Last Post: 11-28-2011, 02:45 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