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?