How do I shift the x-axis to the border line

[csangang]

I'm trying to update graphs for scientific journals-style publications and can't seem to figure out how to move/shift the axis bar to the solid line border. Is this even possible with excel?

Please see attached figures. The heat flow one is my graph and the other is how I would like it to look (the border with the x-axis tick marks on). Basically I'd like my graph to have a border and the x-axis outside tick marks sitting at the very bottom of it. Hope I was able to explain that clearly. Thanks!

 

[6StringJazzer]

Right-click on the vertical axis, select Format Axis from the menu. Then click the button for Horizontal Axis Crosses > Axis Value and enter -2, which is your minimum value on the vertical axis. If your vertical axis range changes you will have to update this manually.

 

[csangang]

Right-click on the vertical axis, select Format Axis from the menu. Then click the button for Horizontal Axis Crosses > Axis Value and enter -2, which is your minimum value on the vertical axis. If your vertical axis range changes you will have to update this manually.

View attachment 73394

OMG you're a life saver! Thank you!!!

 

[6StringJazzer]

Glad it worked for you! Please mark my post above as the solution.