Excel 2013 - Maintain Date formatting - Pivot to Graph

I am trying to maintain the date formatting between the pivot table and the corresponding graph.

1. In the pivot source data the field is populated using this formula: =DATEVALUE(TEXT(G2, "m/yyyy")) where G2 is a date field in mm/dd/yyyy hh:mm AP/PM format.
2. When i create a pivot table the "Month" column shows up as mm/01/YYYY and i can reformat it to MM-Y format but when i create a chart from it the y-axis shows up as mm/01/yyyy format and i cannot change it.
3. I am using Excel 2013

Does anyone know how to do this?  


Tablesample graph
itsmeharAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saurabh Singh TeotiaCommented:
Can you post your sample file where i can look and fix this for you..

Saurabh...
0
itsmeharAuthor Commented:
here you go ...
sample.xlsx
0
Saurabh Singh TeotiaCommented:
Since i didn't had the associated raw data i created one for my own reference..Now if you see sheet1..thats the raw-data and then on sheet3

I created two pivots one is by using the group by function of pivot table and then create a table and then second adding a formula in my raw data first and then using it which gives you the exact thing what you are looking for..

Again i was working on 2007 and you work on 2013 so you can change the graphs accordingly in 2013..

Saurabh...
Saurabh...
sample.xlsx
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Saurabh Singh TeotiaCommented:
Also i looked into your data and in your data you have a blank row in your raw data..Now if you delete that blank row and then play around with your dates it will behave the manner you want to as because one blank row entry..it's not recognize the entire column as date..

Saurabh...
0
itsmeharAuthor Commented:
Saurabh,
I am not sure what you are recommending, if i change the data set and it will obviously work. I was trying to figure out How to maintain the same formatting in the graph as the pivot table or at least change it in the graph itself.
0
Saurabh Singh TeotiaCommented:
Okay what i'm saying is no matter what you will do it won't work and the reason for the same is that in your data set you have a blank row which is messing up dates you need to delete that blank row in order to consider them as dates and once you delete them you will be able to format it..

Also the sheet that i uploaded i suggested you two other ways you can do this as an example for you to look..

Saurabh...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

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.