Bar charts with negative values and label position

G

Guest

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

Guest

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

Graph Negative Values as Positive Values 0
Stack bar charts with positive and negative numbers 2
Stacked Color Charts 1
2007 move axis label & add zero line 1
Changing the data label position below the chart axis. 2
change the position of X-axis labels 2
Positioning x axis at bottom of chart with negative values 5
Data labels along below x axis when y axis has negative values 1

Top