Jul 02 2020 08:11 AM
Interesting question, indeed.
There are probably a number of reasons. My opinion is that Access is, after all, a tool for the creation of relational database applications, and as such Microsoft always has, and always will, place greater priority on features that improve managing data than on features for displaying it.
Another possible reason is that many developers have not been particularly concerned about it and have not made it a priority request because it is so easy to automate Excel to handle that display function while managing their data in their Access relational database applications.
Beyond that, there are other considerations too. For example, starting in the last couple of versions, Access has begun to incorporate features of modern charting. As that work progresses, it seems highly likely that Access will become better at it. However, keep in mind that, for the most part, whatever resources Microsoft has to deploy for Access are more likely to go into aspects of improved data management.
Jul 03 2020 04:19 AM - edited Jul 03 2020 05:18 AM
Aug 22 2022 04:07 PM
Sadly, @ordnance1, once upon a time, Access had pivot tables and pivot charts. They were quick, comprehensive and easy to use... then they were gone. The monthly chart packs we had deeply integrated with the the Access app had to be recreated in Excel and the process and the final solution was just awful.
Modern Charts don't even come close. After 4 solid weeks of effort we still can't get the charts to work reliably with Azure SQL queries and so we've returned to the OLE-driven Excel / Power Query approach.
Let's hope things improve, now that Access provides a viable frontend for Azure databases.
Aug 23 2022 02:47 AM - edited Aug 24 2022 06:06 AM
Thomas Moeller offers it for free not only for static charts, but in his new project also for pivot charts. See my interview with him and the links to his projects below the video on Youtube.
Aug 24 2022 06:33 AM
Hi @Karl Donaubauer,
Thanks for this. I have been exploring Thomas' Better Access Charts. They're excellent, but sadly miss the settings necessary for changing the font sizes on the axes. I've played with the code (as suggested by Thomas) but it's complicated. I have no experience of Chart JS, or any JS, for that matter... so it's been a steep learning curve.
Our preference would have been Microsoft just restoring (and updating) the pivot and charting functions... but alas, no hope of that.
Thank you for the suggestion though.