Results 1 to 6 of 6
  1. #1
    salonikije is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Location
    Montenegro
    Posts
    21

    Question Is it possible to count date in XLS file, create a modern look chart and

    Dear,
    Is there any way to create external XLS or XLSX file which would count data from Access, create a modern look chart by using this sums, and then linked it in Access again, to show that modern chart in a report?
    Last edited by salonikije; 05-10-2017 at 04:34 PM.

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Not sure what you are asking? You can export data from Access to Excel, you can do graphs in reports in Access.

  3. #3
    salonikije is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Location
    Montenegro
    Posts
    21
    To explain a question a little better.... As I see, charts in Access have a very old design....


    So, I would like to link extrenal XLSX file to my Access database which would collect counted data like: all tasks, all finished tasks, all ovedue tasks, all rejected tasks and all postponed tasks and from that data create a modern look chart in Excel, which will be updated on any change in Access database (like a extrernal small database for this purpose). And again, insert that chart again in one of my reports.


    The result which I want is to have a modern look chart in my Access report, which will be automatically updated on every change of task status in database.

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Create the chart in Excel based on values in a second worksheet
    Export a query to this second worksheet
    Open the xlsx and print the chart to a pdf file
    Your report will contain this pdf

  5. #5
    salonikije is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Location
    Montenegro
    Posts
    21
    Dear aytee111,
    Can you give me a detailed intructions how to do that, because I'm a beginner in Access?
    Especially this part with a query...

  6. #6
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I suggest that you get a basic understanding of Access before attempting something as complicated as this. Then come back to us with specific questions.

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

Similar Threads

  1. Limit chart to date range , Chart isnt updating .
    By fluffyvampirekitten in forum Access
    Replies: 5
    Last Post: 06-30-2015, 12:27 AM
  2. Replies: 2
    Last Post: 04-06-2015, 12:08 PM
  3. Using Date and Occurence count to create a name
    By DatabaseIntern in forum Forms
    Replies: 1
    Last Post: 07-11-2013, 11:08 AM
  4. Replies: 9
    Last Post: 01-29-2013, 06:44 PM
  5. Replies: 0
    Last Post: 03-26-2011, 09:59 AM

Tags for this Thread

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