X-axis format for dates
If you have a graph that has an x-axis containing dates, when you try to format that axis, the min and max look like this: 42153 and 42369 that I take correspond to the number of days elapsed since "the big bang or something I guess". It would be nice if we could actually have for these a date picker so that I can select min at "10th Nov 2017" and max at "29th Jan 2018"
Nikolaj Kyndby Hentzen commented
Also better control over major/minor units on axis with date format. Eg. select whole hours, months, days, quarters, years etc. as division.
I normally opt for exporting my data to sasjmp (lucky me to have a licens) because in sasjmp this is a breeze :-)
Vanessa Witte commented
I don't know everything on this topic, but I've had the same frustrations, so this is what I know: excel logs their dates by default as serial numbers (beginning in 1900 I believe) then converts to an actual "date" stamp as we know it to look like (ie:mm/dd/yyyy). For whatever reason, the serial numbers will show as the axis bounds when going to insert -> scatter (and probably more types of graphs I am not aware of). I have no idea why in the world this hasn't been fixed yet. Anyways, I work around it by selecting my data as I normally would and going to insert-> recommended charts. Or insert-> column, etc. I'm not 100% sure but I think this only happens with scatter plots.