Change number format of value scale – How to

Change number format of value scale – How to

Overview

How to change number format of value scale.

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
Step 1: Format the axis.
  1. Right-click on the value (y-axis) to show the shortcut menu.
  2. From the shortcut menu, select Format Axis… Afterward, the Format Axis box opens.
How to change number format of value scale - Number format step.
  1. 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.
  2. 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.

Success!

Success!

Related


Excel lessons  Education home  Techronology home