My customers use MS Access 2016.
As I understand there is a common meaning – Access is not good in graphs?
Googled a bit and found people saying graphs in Access is not worth the headache. Other propose Office automation, sending data from Access to Excel. Excel is great also when it comes to graphs.
Is it possible to create a solution where data is created in Access and which opens an Excel file via a command button?
The Excel file must have a pre-defined format - with a specific chart type, chart title, two vertical (value) axes and the Excel file should be saved with a predefined name set in Access.
If someone has done something similar, where can I find sample code?