Custom Value Axis
 

How do I replace only one value to text on the Value Axis? (i.e., -20, -10,
TEXT, 10, 20)etc.

You might want to use Rob Bovey's XY Chart labeler found at www.appspro.com

"Maureen D." wrote:

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/
_______

Maureen D. wrote:

How do I replace only one value to text on the Value Axis? (i.e., -20, -10,
TEXT, 10, 20)etc.