Based on my search, to achieve your requirement, we could To get more info about this issue, seeįormat pane button for the new chart types does not work.Īnd then I tested with Excel for Windows, find it's not feasible to change the range of the x axis (make 60 or 10 as the lowest class), the Underflow bin doesn't mean the lowest value for the x axis. We cannot open the format pane of those new charts for further configuration.
Firstly I'd like to explain that there was an issue reported for those new Excel charts in Excel 2016 for Mac.
