How do I make a custom category axis?

[Maureen D.]

I want to name the "0" marker on the category axis (i.e., TARGET) - instead
of "0" but leave the remaining values in place (i.e., 10, 20, 30). Is there
a way to do this (i.e., -30, -20, -10, TARGET, 10, 20, 30, etc.) If not, is
there a way to have the plotted color one color above the "0" and a different
color below the "0"?

 

[Tushar Mehta]

Replace the cell that contains the value 0 with the text TARGET.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005