Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 450
  • Last Modified:

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.
0
fjkaykr11
Asked:
fjkaykr11
  • 4
  • 2
2 Solutions
 
COACHMAN99Commented:
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
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
fjkaykr11Author 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
 
COACHMAN99Commented:
format the source data as mmm-yyyy, destination will follow
0
 
fjkaykr11Author Commented:
thanks for the help
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now