Include PivotCharts as a feature for Excel for Mac.
This feature has been available for Windows users for years. I have Excel 2011 and just can't see the value of upgrading without this feature (as it is, I already have to use a Windows version of Excel to do data analysis).
In Excel for Mac, you can now insert a PivotChart when your data is in a PivotTable. Thanks again for the suggestion and for all your votes and comments.
Steve K [MS Excel]
RIdiculous that this is missing.
i'm trying to use 2016 Excel for Mac and do a simple frequency distribution table via Recommended PivotCharts and it simply does not work..
Pivot Chart absence in the Mac OS version of Office has been a major source of disappointment for me. What's the point in going in a pricey commercial product without those features?
Thanks Scott for having posted some reassuring information: Microsoft is working on it. I'll keep following this thread for more news on the schedule.
Please! pivot tables, pivot charts, dashboards, calculated fields.
Why on earth would I upgrade a product that doesn't do what the windows version has done for years? Could we make that and whatever VBA inequality seems to exist a priority, please?
...Guess it's one less sale for MS.
Help much appreciated - Thx
Scott, when do we actually get a response that is mildly less disingenuous than 'jam tomorrow'. Strikes me and several others that there is in fact no genuine intent to resolve these issues any time soon. Petty excuses and promises do nothing to show intent nor appease those who have been quite deliberately and arguably fraudulent misled
Shubhojyoti Dutta commented
Seems like it is intentional ! :)
Andrew Hewett commented
Its interesting how Microsoft leaves Mac users in the dark when it comes to their standard functions in the Windows versions of their office suite. We need Pivot Charts. Why have Pivot Tables without the ability to create the visual data companion?
Iain Black commented
Excellent to hear that pivot chart compatability is under review for Mac. This will prevent me upgrading my current office 365 account as the feature is vital for my job.
Larry Yuen commented
No sure why this is taking so long to add through product updates for the 2016. Seems like it is a great companion tool to Pivot Tables and for doing business analyzes work. Kind of disappointing that there is such a disparity between platform versions of Office. I thought MS was all about productivity regardless of platform (Windows, Mac, Android, iOS, Linux). Customers are losing patience, get on with it.
Kent Mitchell commented
Please please add this ASAP. It's really can't be that hard given you already have it implemented for Windows and ... who would ship the product without this ...
It would be really nice if Pivot Chart will be available for Mac OS. I don't know why there is no Pivot Chart but there is Pivot Table
Matheus Damasceno commented
We really need PivotCharts for Mac
I was about to upgrade to Office for Mac 2016 in order to get the PivotCHART capability. Fortunately, I read this first. I am also keen to hear whether this is still in development and, if so, any thoughts on when it might be released.
Oscar Hillestad commented
Any updates on this?
I just spent hours creating PivotCharts and Slicers for a company dashboard, only to find that stakeholders with Macs cannot view the dashboard.
I was just at an important meeting, and wanted to show my colleagues some data I had displayed using pivot charts. But I made those worksheets on my Windows desktop. I had my relatively new Mac at the meeting. Arghh.
Please make this upgrade!
Doug Pruiett commented
I see the notes that "Pivot Charts are coming." But they are a year old now. I designed a nice workbook that automates creating pivot tables and pivot charts from some raw external data. Works nicely on the PC. Embarrassed that after I urged the Mac users to upgrade to Office 2016, the VBA code that create pivot charts bombs, and there is not way to emulate the functionality useing "regular" charts. When I use a pivot table as the source for the regular chart, the labels, legend, and x-axis values are hosed beyohd recognition.
Scott Richins commented
Definitely looking forward to this feature coming the Excel. It was one of my favorite, most useful tools when I was on Windows, and I've hated not having it ever since I switched to Mac (7 years ago). Such an amazing tool!
Mark E. commented
I just ran into a Wall at work due to the need for Pivot Charts.
I'm already an odd-engineer (the only EE at my company who uses Office for Mac) and now that I just today (1/5/2016) discovered Mac Office DOES NOT support Pivot Charts, It's making me ask my IT for an additional windows License ($$$) for Office/excel to install & use in my parallels installation. If the damn (unnecessary on Mac) Ribbon UI wasn't bad enough... Office for Mac is now officially embarrassing, missing this key professional feature.