Avatar of Peter Fors
Peter Fors
Flag for Sweden

asked on 

Graphs in Access – can’t make what I want.

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.

I wonder?

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?

* Automation* Access MacroVBAMicrosoft Access

Avatar of undefined
Last Comment
Peter Fors

8/22/2022 - Mon