Custom Value Axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I replace only one value to text on the Value Axis? (i.e., -20, -10,
TEXT, 10, 20)etc.
 
This one's pretty straightforward, and you can use a custom number format. It works
for numbers anywhere, not just in a chart.

Custom number formats have four components, for positive numbers, negative numbers,
zero, and text, separated by semicolons. To replace zero with some label, use this:

0;-0;"TEXT";@

Double click on the axis, select the Number tab, select Custom on the left, and
enter that code above into the box.

If the value you want to replace is not zero, you can override the normal
components. Say you want the value 3 to be different, use:

[=3]"TEXT"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top