<div>
@coachman99, thanks for the reply . Where do I update the custom format in the Pivot Chart? &nbsp;I believe I tried that already but not sure if I did this in the correct place.
</div>


@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.

<div>
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. &nbsp; I tried to change within the sort but it's not working. Is there a manual way to do this? &nbsp; Thanks again.
</div>


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.

<div>
format the source data as mmm-yyyy, destination will follow
</div>


format the source data as mmm-yyyy, destination will follow

<div>
<div class="content wysiwyg-content">
In an Excel 2010 Pivot Chart<br />
The date is displayed as below within the data set (Month-YYYY)<br />
Dec-2013<br />
Jan-2014<br />
Feb-2014<br />
<br />
However, in the chart the date is displayed &nbsp;as (MM/DD/YYYY) &nbsp; <br />
12/1/2013<br />
1/1/2014<br />
2/1/2014<br />
<br />
I can't seem to figure out how to change it in the chart to display the same as &nbsp;the data set. &nbsp;Any ideas? &nbsp;Thanks.
</div>
</div>


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.

Excel 2010 Pivot Chart date display

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.