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).

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

Thanks for the information, Andy!

But is there anyway of actually displaying the labels to the right or left
of the axis depending on whether if it is a negative or positive value? I
would like the labels next to the axis without having to fiddle with the
scale and the data on the graph is best suited for a bar chart. Can this be
done?

"Andy Pope" wrote:

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

Hi,

Have a look at this.
http://www.andypope.info/charts/posnegdlabels.htm

Cheers
Andy

Pearl Quan wrote:
Thanks for the information, Andy!

But is there anyway of actually displaying the labels to the right or left
of the axis depending on whether if it is a negative or positive value? I
would like the labels next to the axis without having to fiddle with the
scale and the data on the graph is best suited for a bar chart. Can this be
done?

"Andy Pope" wrote:


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


--

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