Add the ability to create Pivot Charts in Excel Online
Build the features that allow me to use PivotCharts online I am guessing this is on the Roadmap just putting it here since i do not see it listed.
PivotCharts are supported in Excel Online if they were previously created in the desktop app. We don’t currently support creating a new PivotChart in Excel Online. However, we’ll consider improving this in a future release.
is it possible to use the slicer of a pivot table in excel online if previously created in the desktop app? if YES, how to do it?
As a power Excel user I'm extremely disappointed with Excel online. Among many other limitations and inefficiencies, not giving an option to create pivot chart is the worst. It appears to me that the team that developed online version worked in isolation and did not collaborate with the desktop platform.
So, what's the point of Office 365 online? If you cannot make the applications works as desktop?
Joerg Zufall commented
now we have 2018 and that feature still doesnt exist in excel online :(
No, PivotCharts aren't supported in Excel Online. I uploaded a .XLSB, .XLSM, and .XLSX file to my OneDrive. The three workbooks were the same, just different formats. I had Data Validation on most columns with a lookup worksheet. That worked, but was VERY VERY slow (unworkable). I had PivotTables on one worksheet, PivotCharts build from those tables on another worksheet, and a Dashboard (pie charts) again built on those PivotTables. I had a very simply Worksheet_Changed macro to add additional validation on a couple columns (didn't work). None of the PivotTables or Charts displayed. The workbook was built using Excel 2010.
Gregory Appel commented
A major building block has been laid down - it is now possible to create new Pivot Tables in Excel Online. For more info, visit this Microsoft blog post: https://techcommunity.microsoft.com/t5/Excel-Blog/Insert-new-Pivot-Tables-in-Excel-Online/ba-p/167548
When i click on an existing pivot table i get an error that states that "Creating a pivotchart is not supported in the browser"