Hi, I have a column diagram. The data labels are shown just below the X-axis
for negative values.

The problem is that when columns goes below x-axis they go across the data
labels. How can I move to make the labels go above columns if positive values
and below columns if they are negative?
Sverre

Hi,

This explains how to lower the axis labels.
http://www.andypope.info/tips/tip002.htm

Cheers
Andy

sverre wrote:
Hi, I have a column diagram. The data labels are shown just below the X-axis
for negative values.

The problem is that when columns goes below x-axis they go across the data
labels. How can I move to make the labels go above columns if positive values
and below columns if they are negative?
Sverre

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info