Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pearl Quan
 
Posts: n/a
Default 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).


  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

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
  #3   Report Post  
Pearl Quan
 
Posts: n/a
Default

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

  #4   Report Post  
Andy Pope
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I add values, labels and percentage for pie charts? coops-eng Charts and Charting in Excel 1 February 1st 05 05:23 PM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 02:04 AM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 07:25 PM
Is there a way to have two values (percent and number) in a label. msmiller613 Charts and Charting in Excel 1 December 15th 04 04:47 AM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"