Thread: Bar charts with negative values and label position

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