I need to format my VALUE AXIS with postive numbers above and below the zero
value on the axis:

8,000
6,000
4,000
2,000
0
400
800
1,200
1,600

I know it can be done as I am looking at an existing COLUMN chart in EXCEL
2002.
The chart has both primary and secondary Value axes. One series is attached
to the primary value axis and one series attached to the Secondary Value axis.
The primary Value Axis has a custom number format that hides all the
negative values. The secondary Value Axis has a custom number format that
hides all the negative values and the zero value. This axis is also
formatted so its values appear in reverse order.
So you end up with ZERO through 8,000 visible on the Primary Value axis
(above the horizontal category axis) and 400 through 1,600 visible on the
Secondary Value axis (below the horizontal category axis).

There are also primary and secondary Category Axes. The Secondary Category
axis is formatted to be invisible. When you 'flip' the category axes (by
either selecting or de-selecting 'Value axis (Y) crosses at maximum
category) both value axis ranges combine for the final result as described
above.

Whenever I try it, however, one set of value axis labesl always 'erases' the
other set of value axis labels.

Any ideas?

PS: I'd be happy to attach the existing EXCEL file to an e-mail if anyone
would like to see this chart.

Thanking you all in advance,

Mike