'MS Access Modern Charts - VBA adding trendline

I would like to use VBA to format MS access modern charts in forms, for example adding a trendline, turning on data labels etc. I have searched but cannot see any methods or data structures to do this. Can anyone point me in the correct direction?

vbachartsms-access-2013


Solution 1:[1]

This may give you what you want.

https://www.youtube.com/watch?v=0QADS5XxVIs&ab_channel=Microsoft365

Keep in mind...Access is a NOT a great tool for creating charts. As an alternative, you may want to import your data into MS Excel, from Access, and create your Trend Line in Excel. There are so many ways to move data between Access and Excel, back and forth, so if you get stuck with one app, just switch to the other app!

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 ASH

Related Questions

How do I get the paragraph number of the currently selected paragraph in Microsoft Word into an AppleScript variable?

Retrieving custom property value from received mail using GetProperty (which was set using SetProperty in Outlook VBA)

VBA to copy a file from one directory to another

How to add icons to emails in Outllook?

I keep assigning a value to my variable but it stays empty

Check if a cell from a selected range is visible

Create table from data on a worksheet with specific name and add column

Using VBA to query a SQL Server table in Excel

How can I generate a "Social Golfer" matrix for worker seating arrangement?

How to stop scroll bar auto jump in vba

Delete a mailitem permanently in outlook

If IsEmpty then go to column A but in same row and extract that data

Fetch data from website table using vba

How can I use a for each loop on an array?

VBA - worksheet object is hidden