Results 1 to 5 of 5
  1. #1
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    197

    graph source problem

    Hi,
    i have a chart that is visible when i set the rowsource to a query, but invisible when i set the rowsource through vba using the same sql of the query.


    maybe i have to specify axis, values etc etc?

  2. #2
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    206
    Check out this link, it shows how to address each and every Chart Object element in VBA and as how to manipulate them: https://www.msaccesstips.com/2008/06...ct-in-vba.html
    You must activate the chart in design mode to modify the chart object elements, save after changes and open it in preview mode.

  3. #3
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    197
    that's very useful, i wasn't able to find something similar. I'll check out and then i set the topic solved, many thanks

  4. #4
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    197
    i think i found the problem
    how can i set this property in vba? sorry it's in italian but i think you can understand

    Click image for larger version. 

Name:	Cattura.PNG 
Views:	10 
Size:	4.8 KB 
ID:	44428

  5. #5
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    197
    for some reason now it works
    i think the page you linked is referred to normal charts, i use modern charts. i found the official documentation but it's not so good, can you suggest me something better about modern charts?

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

Similar Threads

  1. Replies: 3
    Last Post: 12-21-2019, 06:33 PM
  2. Replies: 19
    Last Post: 06-26-2018, 07:13 AM
  3. Replies: 6
    Last Post: 09-24-2017, 05:59 PM
  4. report with subform graph problem
    By cuddles in forum Forms
    Replies: 1
    Last Post: 05-28-2014, 03:24 PM
  5. MS Graph problem with X and Y components
    By Triztan in forum Reports
    Replies: 1
    Last Post: 07-05-2012, 11:27 AM

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 - Senior Forums