Hi,

This may help,
http://www.andypope.info/tips/tip002.htm

Cheers
Andy

Pearl Quan wrote:
In a bar chart containing both positive and negative values, the X-axis
labels (indicated by the Category X series) display over the negative bars of
the chart. Is there a way of moving the negative value labels to the right
of the axis? I have seen this in both Excel 97 and Excel 2000.

To reproduce,

1. Create a spreadsheet with the following in cells A1:B5:

abc 100
def -400
ghi 200
jkl -150
mno -200

2. Select A1:B5.

3. Press the chart wizard button and choose a bar chart.

4. Click the FINISH button.

I have seen a similar post for this issue for Works for Windows (Article ID
: 113858).



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info