Enable Axis Format For New Chart Types in the Excel 2016 for Mac 16.9 Release
In Excel 2016 for Mac, new chart types were introduced, including Histogram, Tree Map, Sunburst and Box and Whisker. When attempting to format the X & Y Axes, either the Format box appeared with no parameters, or no Format box shows at all. This is critical, core functionality and is needed ASAP, for example a 16.10 update. With my specific case, /i was trying to adjust Bin parameters on a Histogram, and the Format Axis box never appeared.
We’re late updating the status on this one, but this has been completed, so you should be able to do all the formatting options for the newer chart types mentioned in this suggestion.
Steve [MS Excel]
R. Spahl commented
If you click on the series in the chart area, bin width becomes available in the Format Data Series window.
A Mac user here, the histogram bin formatting functionalities still do not appear on my Excel. Could you assist? Thank you.
Histograms- I don't understand why you can't TRULY customize the horizontal axis settings. I want it 8 bins, 10 wide, and I want them to start at 20. Instead Excel will let me change 1, 2 of the settings but not all 3 at once. The minute you try to customize a 3rd setting it just auto-formats. Why? It is easy to customize the histogram settings using the analysis toolpack but when you have to to 30 histograms it's sooo much manual work.
What is your problem with making user-unfriendly designs so much??? Do you hate your customers because they're 9/10 a captive audience forced to use their companies enterprise software??
Hey we needed support excel doubt in vlookup check to lookup value same but table aray as different what they solution
Keep it up
Yeah, they fixed it back in Excel 2016 Mac 16.14 (180602).
Try double clicking on the bars in the histogram instead of double clicking the axes, like you'd usually do. I guess the logic is you're editing the buckets, not the axes.
Dwight Erskine commented
Any more updates on this? Microsoft hasn’t responded in 6 months.
Yes, I'm happy to say you are. Try double clicking on the bars in the histogram. Don't ask me why it has this behaviour, it's unexpected, as your experience shows.
Jill Folkerts commented
My Excel version 16.16.1 still does not have the capability to adjust the bin widths/sizes or add an underflow/overflow bin. Am I missing something?
I'm excited to see that the developers have now added this to Excel 2016 Mac 16.14 (180602), which is now available in the Insider Slow release channel.
Thanks folks! I'm really looking forward to using this.
If anyone has any good links to resources about how to adjust bins to reveal new information from histograms, please let me know.
Im not able to insert columns
Not able to use spell check
They are not enabled /. Dont know how to get them turn on
Dwight Erskine commented
Its now the 2nd of May, I'm on 16.14 (Insider Fast Build), and its STILL not fixed. The Histogram Bin sizing is by far the biggest frustration.
Kind of need to pass a stats class and at this point my Mac is useless because I NEED to format histograms. The function is useless without it.
I am trying to format a statistical chart, so must be able to choose bin widths and boundaries, but I cannot even get Format Axis to show on my Mac. Pretty fundamental omission. Please fix urgently
Agreed. The ability to format the axes on a graph is fundamental. Please fix ASAP. It is great to have the ability to make box plots, but it the user cannot scale the axes this ability is useless. Thank you.
Tariq Khaleqe commented
What I find hilarious is that choosing bin size is critical for histograms. This SHOULD be included no matter what. I fail to logically understand why Microsoft would remove it!
Above all this post was made in Jan 2018. Its March. Nothing has been done. Microsoft you need to fix this immediately!
This must be fixed ASAP, if not the new chart types have very little value
It seems that the developers are aware of it, it's not fixed in 16.11 (Insider Preview) but they "will have this fixed soon"
February 7, 2018 release
Version: 16.11 (Build 180206)
New or improved Features
If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.
Fixed several crashes.
Fixed a problem where calculations were taking longer than expected when using multiple threads.
Excel now shows the number of recent documents specified in MacOS "Recent Items" preference.
This is still considered a preview of the next major version, so we expect to see some issues. Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window. Here are a few things we're already aware of:
If you create a PivotChart, the ribbon tab to adjust the format of the chart will not appear. We will have this fixed soon.
For the new chart types, Sunburst, Treemap, Waterfall, Histogram, Map, and Funnel, the Format Pane can't be opened, so there are some chart options that can't be adjusted.