Excel: Need to move the hash marks

As you can see in the chart, the hash marks do not line up with the dollar amounts on the X-Axis.

I would like $5K to be under a hash, and every hash to have a number under it.

Graph
Here's the Excel.

ThreeYearCosts.xlsx

Thanks
newbiewebSr. Software EngineerAsked:
Who is Participating?
 
Neil FlemingConsultant and developerCommented:
If you right-click the axis, and select "format axis" you'll see an option for "axis position". change it to "on tick marks"

See attached.
ThreeYearCosts.xlsx
0
 
newbiewebSr. Software EngineerAuthor Commented:
thanks!
1
 
Neil FlemingConsultant and developerCommented:
pleasure
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.