To do this, right-click the chart’s Y-axis and choose Format Axis > Number tab. Click on Custom – as you can see, you can create custom formats for chart axes too. In the Type box, type the following ...

This guide will show you how to create a Histogram Chart in Microsoft Excel. Add your data, click on Insert, Format it and you are done!

How to create conditional formatting rules in Excel Once the custom value formats exist, you can apply them using conditional formatting rules. Right now, the format is set to General.