• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1671
  • Last Modified:

Excel; X-axis labels show on chart

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.
0
sweasel
Asked:
sweasel
  • 2
1 Solution
 
bruintjeCommented:
Hello sweasel,

the only way to prevent that from happening is setting the
-choose format axis on the y-axis
-next the tab scale
-check the value for y crosses at category (x-axis) at 0 or the much lower value in your case


HAGD:O)Bruintje
0
 
mitsubishiGalantCommented:
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
0
 
mitsubishiGalantCommented:
High - > will display the labels on the top, low-> will display the labels on the bottom.

Guna
0
 
sweaselAuthor Commented:
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.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now