0

I have a line chart in Excel where the vertical axis is below 0 as some values of my graphs are negative. I have a label at -2.0%. The problem is the associated horizontal line at -2.0% intersects with the horizontal axis labels.

Is it possible to remove this line while letting all others remain? Or can I remove a single axis label (including its line)?

My workaround right now is to change the scale because the only other alternative I see is to have the labels above the chart, which is not what I want.

Improve this question
2
  • 3
    an image of the chart may help others understand your problem
    – PeterH
    Jun 21, 2019 at 7:58
  • "Is it possible to remove this line while letting all others remain? Or can I remove a single axis label (including its line)?" - no, that's not possible in Excel
    – Máté Juhász
    Jun 21, 2019 at 7:59

1 Answer 1

Reset to default
0

Here is a kludge:

  1. Select the cell with the label in question

  2. Type in one or more carriage returns (altreturn) before the text

You'll need to experiment to see how many carriage returns will be needed

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .