Excel 2010 Pivot Chart date display

In an Excel 2010 Pivot Chart
The date is displayed as below within the data set (Month-YYYY)
Dec-2013
Jan-2014
Feb-2014

However, in the chart the date is displayed  as (MM/DD/YYYY)  
12/1/2013
1/1/2014
2/1/2014

I can't seem to figure out how to change it in the chart to display the same as  the data set.  Any ideas?  Thanks.
LVL 3
fjkaykr11Asked:
Who is Participating?
 
fjkaykr11Connect With a Mentor Author Commented:
I think I found the answer on how to move the data manually to display in the correct order:
If you click on the column (or row) header that you'd like to move, the cell will be highlighted. Roll your cursor around the edge of the cell until your cursor changes into the picture of a miniture uni-directional arrow. Right-Click once and the entire column will be highlighted. Once the column is highlighted, again, roll your cursor around the edge of the highlighted column until your cursor changes into a 4-directional arrow. Right-click and hold... this will allow you to drag the entire column to a different place.
0
 
COACHMAN99Connect With a Mentor Commented:
do custom format mmm-yyyy
0
 
fjkaykr11Author Commented:
@coachman99, thanks for the reply . Where do I update the custom format in the Pivot Chart?  I believe I tried that already but not sure if I did this in the correct place.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
fjkaykr11Author Commented:
If I redo the pivot chart with a text format for the month/year then it displays correctly in the data set and the chart. However, it is not sorting correctly, be default it is sorted alphabetically.   I tried to change within the sort but it's not working. Is there a manual way to do this?   Thanks again.
0
 
COACHMAN99Commented:
format the source data as mmm-yyyy, destination will follow
0
 
fjkaykr11Author Commented:
thanks for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.