graph source problem

[diegomarino]

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?

[apr pillai]

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.

[diegomarino]

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

[diegomarino]

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

[diegomarino]

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?