Bar charts with negative values and label position

P

Pearl Quan

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

Pearl Quan

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - Chart Data Label positions 1
Changing the data label position below the chart axis. 2
2007 move axis label & add zero line 1
Stack bar charts with positive and negative numbers 2
Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Labeling on independently stacked line chart 0
Adding a line to a population bar chart 0
One extra x axis item that wont go away - can anyone help? 3

Top