I'm not a huge fan of Access charts at all, however, I'm working on a dashboard project that would require the extensive use of chart objects among tables and other things.
Are there huge design related practices against using an Excel linked OLE object that is updated or refreshed using VBA. I'm an above average VBA coder and I'm comfortable that I will find a way around this preferred solution should there be no serious bad practices in using linked OLE objects through the Unbound Object Frame.
What are your thoughts, critique, hurdles to watch out for, basically anything you can think of will go long way.
Much appreciated
Thank you