When I make a scatter chart of a column of dates versus a column of data values, the X axis doesn't show the actual dates. Instead, it shows 00-Jan-00, 02-Jan-00, etc.
However, if I make a column chart, the correct dates are displayed.
How can I fix this?
However, if I make a column chart, the correct dates are displayed.
How can I fix this?