• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Project Timing chart

L

LadyBlack

New Member
Hello, me again. I'm trying to create a project timing chart. I have had a look at the way this site advises to do them, but have fallen at the first hurdle. I have a table with three columns. The last two columns are labelled, "Start" and "Duration". I did have "End" as well, but it just confused matters. When I use the chart wizard, it becomes a chart with two columns marked "Start" and "End". The data in the first column is the start date (01/01/2010), duration is 90 and the end date is 31/03/2010. When I use the chart wizard on it, I get two columns, one labelled "Start" and the other "End". The dates at the bottom begin in 1900. I was trying to get Excel to recognise the dates as falling between the dates I could then set on the bottom of the chart, and to simply colour in the bar between them. However, it didn't work. I then tried a stacked bar chart (following another advice sheet) but then the axis at the bottom comes out labelled according to the number of units I set to be between points. So if I put 30, for example, any month with 30 days in it will come out fine. If it has 31 days, however, the next label appears as 31st, and then the next one will be 2nd.


Can anyone advise how to do a simple chart, so that Project 1 can be shown to be taking exactly 3 months?


Thanks
 
Try Setting the X-Axis Scale from 40179 to 42269

which is the decimal values for the dates you listed

Set X-Axis Major Grid to 7 or 14 or try other values to suit
 
You must log in or register to reply here.
Back
Top