I was thinking more along the lines of converting time zone abbreviations (https://en.wikipedia.org/wiki/List_of_time_zone_abbreviations). So even though the Eastern Time Zone can observe EST or EDT depending on the time of year, EST is always UTC−05:00 and EDT is always UTC−04:00. Then we don't run into issues of region or time of year.

I realize that this doesn't address the language issue, but this can perhaps be addressed by using abbreviations in the language that the user is using for Excel.

You are not tackling the right issue. If you are accidentally pressing Close so often that it becomes a problem, then that is your issue. The issue is not so much the fact that Excel boots you out of edit mode. Maybe it's a user interface issue, or maybe you are not being careful enough about what you click on.

Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

We are actively working on a plan to provide PivotCharts in Excel Mac desktop.

7/26/16
As noted previously, we are actively working on providing PivotCharts in Excel Mac desktop. This is a large project with many dependencies. As such, we cannot provide any details on when it will be available. However, I’ll update this thread when we get closer to a release timeframe.

Thanks for logging this item, folks. This is actually significant amount of work that is in our backlog. You can help by drumming up support for this (i.e. number of votes), which will help us balance this work with higher priority against other items.