|I have a problem in a Gantt Chart that I'm working on. Everything is perfect except for the dates across the y value go from 9/14/11 - 5/6/13. I downloaded this as a template from Microsoft's template gallery but cannot get in contact with the author to find out how they formatted these dates. I need the y value to read April, May, June, July, August, September, October. I just want months, no days but if I had to define days, I guess I would go from the first of each month. I'd rather have the months written out rather than 01/04/12, 01/05/12, 01/06/12, 01/07/12, and so forth. I am in Europe, so the dates would have to be written DD/MM/YY.|
I have spent no less than 6 hours trying every way I can think of to change this and scouring the internet for help and I've only come up with solutions to simple y value problems that are unhelpful. The original author had the y values "linked" to a source but I cannot find this source. I've tried unchecking it, playing with the scale under 'formatting axis', and even deleting the column and creating a new one which really messes things up.
Is there anyone out there that I could email my file to in order to have a first hand look to see if they can figure out how to change this and then let me in on the secret in elementary school terms? I cannot explain the trouble I'm having in any other way and I am such a basic user when it comes to Excel, I'd likely have no idea what anyone is talking about if they describe it above a very elementary level. Ironically, Excel for Dummies was no help.