Provide a modern Chart control
Please, give us the Chart control, at least, like Excel has. It's impossible to build an interactive dashboard in Access because of lack of functionality and Win95 look. For example, out-of-the-box BoxPlot chart in Excel 2016 is awesome. Why not Access? Or even interactive functionality like PowerView has.
New and modern chart types are now available to O365 customers.
Read more about them here https://techcommunity.microsoft.com/t5/Access-Blog/Introducing-new-and-modern-chart-types/ba-p/193479
This is good news. The removal of pivot-charts and lack of a rich built-in alternative is by far the number one reason my company has not upgraded Access.
Make the charts easier to first create as well.
Basically now, you throw a chart on the report with the absolute GARBELDEGOOK that passes for the data that it thinks it should show and then ream that all out of the rowsource to put in the data you want to see. The 4000 row limit isn't fun either, having to code out the VBA to take your data and average it so that you get down under that limit.
Pat Hartman commented
Thanks for taking this on MS. If you use the same model that Excel uses as you did with previous charting objects, it greatly helps the Access folks because Excel has a macro recorder and by turning on the macro recorder in Excel as we manipulate the chart, we can generate VBA code that can be used in Access to set the chart properties with code.
Craig Dolphin commented
Late to the party but could not agree more. I do not want to have to petition IT to allow another product in our environment. Access needs a better charting solution built-in.
Tom Wickerath commented
Isn't it possible for you to provide a better charting experience *within* Access? Scott Hall's comment is spot on: "The charting system in Access is a joke." I think the same charting engine is used as Excel--is this correct? If so, is it that difficult to expose richer charting capabilities?
Power Bi may be great, but it is another obstacle that many people will not be able to navigate in corporate environments.
Scott Hall commented
No kidding. The charting system in Access is a joke. I love the program but it produces charts to shabbily that none of my users want them. I have to do workarounds to use the Excel engine instead.
John Ford commented
I would like to see Power View and/or other Power BI features capable of being incorporated into forms/reports. Access is already table driven with views (via queries).