Excel charting, horizontal axis move to bottom

Anonymous
2021-02-15T19:12:21+00:00

Hi, I'm asking for help with an Excel charting problem concerning the horizontal axis. In this example, you can see that I've set labels to "Low," so they appear along the bottom. But the horizontal axis and its tick marks -- I can't figure out how to move them to the bottom. I'm aware that I could set "Horizontal axis crosses" to -0.16%, but that produces a different effect. I just want to move the axis line. I can supply a workbook with this chart and its data.

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} votes

12 answers

Sort by: Most helpful
  1. Anonymous
    2021-02-16T18:43:02+00:00

    As you can see in my original example, I have labels set to "Low," which is what your instructions advise. It doesn't move the axis and its tick marks to the bottom.

    Perhaps if you turned off the box around the plot area and turned off gridlines you would understand.

    0 comments No comments
  2. triptotokyo-5840 36,676 Reputation points Volunteer Moderator
    2021-02-16T19:10:38+00:00

    This:-

    Perhaps if you turned off the box around the plot area and turned off gridlines you would understand. 

     - doesn't make the slightest difference and the item at this end remains as passed testing.

    0 comments No comments
  3. Anonymous
    2021-02-16T19:31:08+00:00

    Here is my workbook. Please show me moving the horizontal axis to the bottom of the chart.

    https://wichitaliberty.org/wp-content/uploads/2021/02/Charting-examples-v1.xlsx

    0 comments No comments
  4. triptotokyo-5840 36,676 Reputation points Volunteer Moderator
    2021-02-16T19:55:59+00:00

    Here is my workbook. Please show me moving the horizontal axis to the bottom of the chart.

    https://wichitaliberty.org/wp-content/uploads/2021/02/Charting-examples-v1.xlsx

    Bob - I've just looked at that and it's already in the right place.

    0 comments No comments
  5. Anonymous
    2021-02-16T21:31:07+00:00

    Could you please show me a screen shot?

    0 comments No comments