This quick lesson shows you how to change the number format of a value on the y-axis of a column chart, in Excel.
So, in the above chart, we want to change 200 to $200, and keep all other values the same. Overall, we think that will add value to the chart, and make it look better.
Steps to change number format of value scale
Follow the steps below to modify the number format of an item on the value scale of a column chart.
Step 1: Format the axis
- Right-click on the value (y-axis) to show the shortcut menu.
- From the shortcut menu, select Format Axis… Afterward, the Format Axis box opens.
- Under Axis Options, scroll down to the Number section and select Custom from the Category list. This will allow you to enter a custom number format for your value scale.
- For the Format Code, enter [=200]$#,##0;#,##0, and click Add.
So, what we just did was enter a conditional format. In essence, it says, if the value equals 200, then format it as $#,##0. Otherwise, keep it as #,##0. Basically, $#,##0 is the true result, and #,##0 is the false result.
Keep in mind, if you have more than one 200 on the scale, it will format all of them as $#,##0.
Last, you can learn more about number formats here.
- Add data labels to a chart in Excel – How to
- Change the value scale of a chart to improve view – How to
- Make the plot area of your column chart better – How to
- Proving 0 is false and 1 is true with AND(), in Excel