Chart macro not displaying correct x-axis dates

[Karie Kelly]

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?

[Bob Swift · Accepted solution]

Shouldn't you be using MM for month? mm means minutes?

[Karie Kelly]

Yep - that's it! Thx.