how to move horizontal axis labels in bar graph

Anonymous
2017-10-26T03:11:22+00:00

Hello,

Please have a look at the graph below:

How can I change the position of the horizontal axis labels (i.e. Jan, Feb, Mar,...). They are overlapping with the bars and I think it would look cleaner if they were in a clear area, like above the bars. When I hover over it, a box highlights around it and the mouse cursor transforms into a four-way set of arrows, but when I click and drag, nothing happens.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} vote
Answer accepted by question author
  1. Anonymous
    2017-10-26T05:59:52+00:00

    Hover the mouse over one of the axis labels until the tooltip pops up that says 'Horizontal (Category) Axis'. Right click and select Format Axis.

    Then under Axis Options ->Labels set the label position to High

    8 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful