Hi, I have a discharge date from Jan 2017 to September 2018. I'm trying to get a line chart with just the 3 character month and 2 character year. When I select custom format and type in MMM YY, the values in the axis do not change. Currently, the full month and the full year are showing. A few months are skipped but, generally, every quarter is visible with the exception of a few months. How can I get the 3 digit month and 2 digit year to show?
1 answer
Go to format, Dates: Select custom and Format type MMM, YY and it will display Jan, 18
