Histograms for Excel 2016

I am having trouble with Histograms in Excel 2016 for Mac. I am able to insert a histogram, but can't make any edits to the histogram (change scale on axis, change fill color in plot area, etc.). If I double click on an axis on any other chart type a pop up box comes up with options, but this doesn't happen on a histogram any other type of statistical chart. I am not having this trouble with any other chart type, just with statisticals. Any assistance or guidance would be much appreciated.
Answer
Answer

Hi John,

It is not feasible to change axis on Histogram now.

We understand this may cause inconvenience for you, so we kindly invite you to submit your feedback in our Excel UserVoice via voting for these ideas: Enable Axis Format For New Chart Types in the Excel 2016 for Mac 16.9 Release.

UserVoice is actively monitored by related team and many features have been designed or updated based on Users' feedback.

About "fill color", we couldn't change it by double clicking.

I suggest you try the following steps fill color:

1. Select plot area.

2. Click Chart Design>select Change colors.

Thanks for your understanding.

Qing

If you feel a reply works for you, please kindly vote or mark it as it will be beneficial to other community members reading this thread.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated October 20, 2019 Views 662 Applies to: