Excel help please Home › Forum › Chat Forum › Excel help please Viewing 5 posts - 1 through 5 (of 5 total) Excel help please makecoldplayhistoryMember I’m trying to make a Gnatt chart – a project management type horizontl bar chart showing time taken to complete a task. I’ve used a template from the internet but am stuck on two aspects. 1) the chart begins at a random date. It should be the value of c3, but it bloody isn’t 2) there is a random ‘P’ in the middle of the sheet. I can’t delete it. Can any of you excel gurus help? http://s000.tinyupload.com/index.php?file_id=35954856633247789075 Many thanks Posted 1 year ago atlazMember For number one the data of your gantt chart only goes to C4, change it to C3 (Chart Design -> Chart Data). Excel being tricky it doesn’t select C3 unless you tell it to start at C3 😉 On a mac I can’t see the P Posted 1 year ago jamiepMember there is no P there – it is because you are viewing it as Print Preview. Go to View tab and click Normal (top left) rather than Page Break Preview Posted 1 year ago jamiepMember there is an error in where Start Date in Number Form points to change the number format of that cell in each sheet and then have the other dates point to that as appropriate Posted 1 year ago makecoldplayhistoryMember Ah, yes. The ‘P’ was for Page Break Preview! Even with ‘start date in number form set to =c3 and the format changed to date, the chart, for some reason, begin at 7/25/16 http://s000.tinyupload.com/index.php?file_id=02290606447034735829 Posted 1 year ago Viewing 5 posts - 1 through 5 (of 5 total) The topic ‘Excel help please’ is closed to new replies.