Excel: Need to move the hash marks

curiouswebster
curiouswebster used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Consultant and developer
Commented:
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
curiouswebsterSoftware Engineer

Author

Commented:
thanks!
Neil FlemingConsultant and developer

Commented:
pleasure

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial