Andy is right, I had the same problem and the data label distance does
not do the trick because it is not designed to do that.

In Excel 2007 Right click on the axis title (x axis) and you'll get
the Format axis menu.
Then you go to the axis option tab (first one from the top) and down
the bottom you have 3 drop down menus.
The last one is called Axis labels. Select 'Low" and you are done!

Mario


On Jun 11, 3:07*am, "Andy Pope" wrote:
Hi,

You question is a little confusing, mainly to do with the terminology.
The Yaxisis normally the vertical valueaxisbut I think you are
describing the Xaxis.
Also you mentiondatalabelbut again I think you are referring to theaxis
labels.

If my assumptions are correct this should help.http://www.andypope.info/tips/tip002.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info"Laura" wrote in message

...

I'm charting some percentages. Many of them are negatives, but not all.
The Y
axisin mychartis more in the middle, instead of on the bottom, as with
normal charts that have all positive numbers. Thedatalabels are
overlapping
some of bars in thechartthat are negatives. I can't get thedatalabels
to
move any further south. I've already changed the 'datalabeldistance from
axis' to the maximum of 1000. Thedatalabels are still overlapping. Is
there
anything else I can try? Thechartlooks terrible with the labels
partially
on the negative bars, please help!