On the primary horizontal axis I can go to Format Axis > Line Color and Style. There I can choose the color and style of the line that represents 0 on the primary vertical axis.

However, with the secondary horizontal access, I can format with color and thickness of the line, but it is located at the very top of the chart, and not at the 0 value of the secondary vertical axis. (see image)

enter image description here

Am I missing a option in the chart controls?

If this really isn't possible, is there a way to draw a line all the way across the chart area (not stopping at the first and last x-axis categories)?

1 Answer 1


Format the secondary vertical axis, and where it says Horizontal Axis Crosses, choose Automatic, which means at zero. (The default for the secondary axis is Maximum Axis Value.)

  • That was it Jon. Didn't think to check the vertical axis properties. Thanks! Jan 29, 2015 at 16:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.