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.
2
-
Why would moving the horizontal axis down to cross at -0.16 not produce the effect you want? (apart from it then being fixed rather than automated, which is a non-optimal outcome if your datasets vary, but this appears to be long-term trend data so it will be a while until that is an issue)– AdamVFeb 22, 2021 at 13:42
-
1That is an option, yes. But we lose the obvious distinction between positive and negative values. Example below.– Bob WeeksFeb 23, 2021 at 15:25
Add a comment
|
2 Answers
I do not think the real X-axis could be moved down.
But as a workaround, we may create another line to shown as X-axis.
- Add a colomn, set the value as 0.
- Right click the chart > Select Data > Add a series in chart.
- Right click the chart again > Change Chart Type > Combo, set Line and tick seconday Axis for this new series.
- Set No Line for previous X-axis (Horizonal Axis).
- Add the gridline (Such as Primary Major Vertical or Minor Major Vertical) for this chart, this action could make the chart more readble.
- Set No Line and no Lable for the Secondary Vertical (Values) Axis.
Someone suggested making the horizontal axis cross at -16%. This works, but I lose the obvious visual difference between positive and negative values. Example:
