<div>
In Format Axis -&gt; PAtterns -&gt; Set Tick MArk Labels to High. That will fix your problem.<br />
<br />
I have to do the same thing through VBcode. If you know the properties please let me know.<br />
<br />
Thanks,<br />
Guna
</div>


In Format Axis -> PAtterns -> Set Tick MArk Labels to High. That will fix your problem.

I have to do the same thing through VBcode. If you know the properties please let me know.

Thanks,
Guna

<div>
High - &gt;&nbsp;will display the labels on the top, low-&gt; will display the labels on the bottom.<br />
<br />
Guna
</div>


High - > will display the labels on the top, low-> will display the labels on the bottom.

Guna

<div>
Good one.<br />
<br />
This is one of two settings I didn't mess with so now I'm going to plaay with the other one.<br />
<br />
Thanks again.
</div>


Good one.

This is one of two settings I didn't mess with so now I'm going to plaay with the other one.

Thanks again.

<div>
<div class="content wysiwyg-content">
The X-axis data labels for a chart appear on the chart whenever the data values go below the &quot;0&quot; value. This leaves the labels mixed in with the plotted data. The offset function won't move the labels far enough off the charts when there are large negative values.<br />
<br />
I've played with all of the chart settings I can find and can't make the labels move below the chart. I give up.
</div>
</div>


The X-axis data labels for a chart appear on the chart whenever the data values go below the "0" value. This leaves the labels mixed in with the plotted data. The offset function won't move the labels far enough off the charts when there are large negative values.

I've played with all of the chart settings I can find and can't make the labels move below the chart. I give up.

Excel; X-axis labels show on chart

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.