Hello. I have a range of dates for my x axis in a pivot chart, for some of my items the y axis goes negative, but it keeps the dates in the middle (along the 0), which sort of looks funny. How can I change it to the bottom?
Hello. I have a range of dates for my x axis in a pivot chart, for some of my items the y axis goes negative, but it keeps the dates in the middle (along the 0), which sort of looks funny. How can I change it to the bottom?
Right click on the axis labels, go to format axis, next to axis labels click the dropdown box and select Low.
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks