Add Pivot Charts back to Access.
The original Pivot tables and Pivot Charts in Access 2007 were very easy to use and a great benefit to builders and users. I am still using 2007 for that very reason, since I have many applications that rely on the pivot functionality and I am a great believer in graphical representation using Pivot Charts.
Thanks everyone for voting and supporting this suggestion.
As you are all aware, Pivot Charts and Pivot Tables have been removed from Access 2013 because the technology they relied on was deprecated (Office Web Components).
Voting and commenting on this suggestion (and on this https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/11510094-put-pivot-tables-back-into-access-surely-a-databa) has been very valuable to us to distill the requirements and needs.
Since Pivot Charts as we all know them, will not come back to Access, we are updating the status accordingly and would like to encourage you to continue and use your free votes to support other suggestions.
Taking pivot tables and charts out of access blew up it’s utility for many people who used it to develop solutions that have been in place for years. It seems like an inexplicable decision. It would be nice if there was a replacement small database system with report making, analysis, and publishing capability, but I’m not expecting it to come from Microsoft.
Access was starved of development for a decade. It’s actually a beast to figure out Access pivot charts, It’s pivot tables are crap compared to Excel, and the VBA model for both are super cryptic. In the big picture it’s probably better and easier to do reporting out of Excel, but just killing pivot tables and chart isn’t the best way to integrate them together. Maybe make a utility to move an existing Access db into a SQL Server db. Make the overall process of data analysis for working people easier to do in a proper modern way rather than devising an unnecessarily complex shuffle between Excel and a now totally antiquated Access. Office is so ubiquitous but MS has forgotten the non-IT data worker. It’s really a bummer.
Guillermo Casas commented
I need pivot back to Access
Put Back Pivot table..when we are upgrade we look forward more features without losing existing facilities.. why it removed ?????? without pivot table how we use especially for priparing mis reports..?? Please put back features immediately.
Look at Excel team - they never ever ruin backward compatibility!
Just bring it back.
John Weeks commented
Very disappointed that pivot table functionality has been removed.
Pivot tables is the reason why a lots of my clients did not mirate to office 2016 and office 365, return back pivot tables and pivot charts.
The fact that you need unnecessary extra steps to create a PivotTable by exporting it to excel plus the need for other extra cell adjustments is a very waste of time and annoying especially when using such tools frequently. Access should have its own PivotTable tool just like the previous versions and not crossing from one program to another. I do not expect to use other program like Excel or PowerBI to get what many of us want when this was seamlessly done through Access by itself. Its an indispensable tool that Access should get back. PivotTables make Access more usable and powerful. WE NEED IT!
Please put pivot back in!
TCHINDA KUETE Patrice commented
The removal of pivot tables and pivot charts prevents my company from migrating to new versions of Office such as OFF 2016 or OFF 365, due to the functional regressions induced in various production application systems.
We will have to stay in Office 2010 a few more years.
MS Access becomes pretty darn useless beyond basic usage without pivot tables. Do you and Microsoft want to enter the age of Data or not?? what a regressive move...
Ms-Access, le seul logiciel qui rétrograde ses fonctionnalités avec les nouvelles versions !
Et qui ne tient aucun compte de l'avis des utilisateurs.
C'est incompréhensible. J'aimerais avoir une explication.
Jo Lynn Foster commented
If Access will be part of our future, pivot tables and charts are a must. Shame on Microsoft for removing the tools we need to maximize the benefits of their products. This fuels us looking for alternatives to Microsoft.
With out these functions my colleges will stop using access. Maybe that is the intention? How can you take away something so useful and uis the only reason I used access in the first place
I was shocked when I couldn't find my charts in access 2016. I cant believe that Microsoft has depreciated this nice feature in new versions. please put it back in newer versions.
Please put it back to Access 2019, we all need it. I believe it's realizable for them to bring Pivot tables even office web components back.
Please put pivot back in
please put pivt chart and pivot table in ms access 2019
Microsoft is only doing this so they can make more money on their other BI applications. This really is insane. This has burst my microsoft bubble. I will be stepping away from microsoft. I was even looking at moving to business central. But seeing this.... Not a company I want to work with if I have the choice.
No Pivot Charts in Access 2019!
I just can't understand your development, you could have the BEST business intelligence tool in access, Tableau is not good enough.
I'm going to be stuck in Access 2010 forever!