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 ...

In Excel, users can add predefined layouts and styles to format their charts quickly. In this tutorial, we will explain how to apply layouts and styles to your chart in Microsoft Excel.

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.