Hi,
I can't find or figure out how to solve this for excel 2016. I have attached the chart. I want the date and tick marks on the bottom of the graph. I can get the dates to comply by selecting "low" for x axis but I can't figure out how to make the tick marks follow suit?
thanks
First, if you are using Excel 2016 I suggest you use the .xlsx format instead of .xls. With .xls you could lose some features when saving.
Select the vertical axis and then format. For "horizontal axis crosses" select "Axis value" and put -20 in the box. This number should always be the same as whatever you enter for the minimum axis value.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
That fixed it. thanks Jeff!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks