I am using the timeseries chart macro, Day, with mm/dd/yyyy. My two columns are Day and Activity,
Day has data such as 04/07/2013, 04/14/2013, 04/21/2013 and Activity has 4,8, and 9 respectively.
When the chart displays, the x-axis shows 00/07/2013, 00/14/2013, 00/21/2013. I've changed the chart type and any place that there is an x-axis to display the date as mm/dd/yyyy, it shows as 00/dd/yyyy. The only chart that displays the date correctly is a pie chart. For bar and line charts it shows the mm/dd... correctly - it just doesn't render the year.
We wanted to use the time series because we are going to graph data across years; thus the full date format is important.
Does anyone know how to resolve this issue?
