Date axis options missing

Copper Contributor

Hi Microsoft Tech Community


I have a problem with the date axis of some of my workbooks.  The dates are formatted as dates and recognised as such.  But when I make a pivot table and then a graph, the dates are not displayed according to the time.  The dates for which there are not data, do not appear and no spaces left for them.  When I click on the more options for the axis, the options for "Bounds" and "Untst" do not appear.  See the printscreen below.



Microsoft Office Support could not find the problem.  REparis to office did not help.  If I start a new workbook it works correctly, but if I paste from this one into a new book, the problem persists.


Thank you


0 Replies