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?
Shouldn't you be using MM for month? mm means minutes?
Yep - that's it! Thx.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.