Download charts december 2009

->>>> Click Here to Download <<<<<<<-

Thankyou Sir for great works done by you, I have a point.. I used the following formula to shade the weekly cell and then used conditional formating.. Could you please share link to an excel file for download instead of zip file. The Zip file hits the firewall roadblock. Rohit: Thanks for sharing your formula. Can you upload the file on skydrive and leave the url here One concern with this approach is that it is often very important to display the Planned and Actual schedules superimposed on each other not available here.

I'm sure it wouldn't be difficult to finagle the conditional formatting to outline the target, and fill in the actual or vice versa , or some other form of formatting that will superimpose the two. The alternative, of course, is creating a graph that does the same, and shows actual versus projected Sal: I agree. Excel has a limitation on the number of 3 conditional formats applied on a range of cells. Also the formats stop if true.

Excel none of these limitations. Ive been playing learning with this and took cognisance of the need to show planned and actual on the same graph. Could Index be used? Jon: Cool, thanks for sharing your formula. However the formula is not working.

I think it missed the other two parameters and only specifies the parameters for AND. If possible, please upload your file somewhere or email it to me at chandoo. Please note i have only changed Rows 9 and After having a play i came up with the following formulas. This frees up the 3rd conditional format. It should read - Please note i have only changed Rows 9 and Thanks for such an elegant solution.

I am trying to update the template and provide another download. I will do it this weekend. I'm feeling very inadequate after reading through these posts and the tips above.

I am a project manager that is trying to get an 'old fashioned' defunked program under control by making everything uniform. I've been able to figure out a lot of what I'm doing on my own, but I've hit a wall with this last part.

Can you please explain what the two different colors on the chart represent light blue, dark blue and the difference between the proposed and actual bars? I've probably taken on more than I should have with a gantt chart, but I'm too far along to give up now. Besides, it'll drive me crazy until I figure it out. The spreadsheet uses slightly intricate formulas to show planned or actual gantt chart. The dark blue bars are that. The light blue ones are the portion of work that is finished.

I am not sure if my answer is helping you. Let me know if you want more help. Fantastic stuff! How can I change the colors of the cells? I want to change the light blue one. You can change the light blue color actually it is white, due to the blue background it looks like light blue by selecting the entire grid and changing the font color. But they are heavy on planning side. They give little insight in to what is happening.

A burn down chart on the other hand is good for understanding the project progress and how deliverables are coming along. According to Wikipedia, A burn down chart is graphical representation of work left to do versus time.

The outstanding work or backlog is often on the vertical axis, with time along the horizontal. That is, it is a run chart of outstanding work. It is useful for predicting when all of the work will be completed.

Hi, everyone, I just found the very interesting web that open my eye on excel. Can I learn how to create the box with world 'plan' and 'actual' inside. Also I notice there is a legend sheet, what is that? Thanl You. Hi, I'm an Excel noob so apologies in advance if the following statements seem foolish.

I'm wondering if the following could become part of the tutorial. Won't go into too much detail yet in case this sort of enquiry is inappropriate to the thread. Thanks, Clive. This is really great stuff - easy tool to use. One quick question - How do i change the grid to display 52 weeks or say 35 to 52 weeks. I am no excel guru so any help is welcome. Ta: welcome to PHD. Clive: Very good idea. I havent really dedicated a whole post to cost aspect. Since cost is directly proportional to effort I left it out.

I will be discussing about effort estimation as part of the 4th installment of this series will be posting it this week. Meanwhile, you can edit the downloadable workbook on this post and add budget details as well.

Sundeep: Welcome to PHD. You can easily add more columns. If you are familiar with how excel formulas and conditional formatting work then it should be fairly easy.

Good luck. Hi, Thanks for the site. Is there a way to add milestones to the chart with no duration similar to MS Project like start, or meeting, or other no duration events?

Excel is a poor mans database and should only be used with cost reporting for regularly used reports. Even then I do not think it is a great idea. Don't get me wrong I use it all the time for project management. Not because I want to use excel to create the reports let alone collect the data. It is because my company is to cheap and ignorant of the processes to buy the software to do project management functions more effectively in less time.

Thanks for posting it. Brian: I disagree with you on "using excel as a project management tool While excel cannot fulfill a large scale project's management needs, it works very well for day to day project management stuff be it maintaining issue logs, change logs, listing and tracking activities, reporting, analyzing. It is simple to learn and easy to work with. I have used MS project and a handful of agile software project management tools, but I find excel quite simple and intuitive compared to these complicated tools.

However, excel has a ton of limitations too. To start with, there is no straight forward way to do even the simplest project management activities using excel. You have to make templates, created models and charts before starting to use it for a real project. That is where this series comes in to picture. My experience is very small and limited. From what I have seen, excel seems like a decent fit when the other choice is learning a complex tool or paying money through nose.

But, I am sure you have different experiences and thus different opinion. Chandoo - I love your posts - I drift back and forward periodically, as a source of expertise and skill. I rate myself as a reasonably serious user of Excel VBA programming - not just recording In addition, it is much more pliable than other products, insofar as its ability to present and manipulate data.

I also accept that it is not purpose built for gantt charting, dependency mapping and WBS development - but let me tell you, it sure can represent the outputs much more effectively! Andin my line of business consulting I aasure you - not all companies understand, invest, or even want to use the more complex tools.

So - thank you for your posts - and I hope all those that stumble on your site, like I did years ago, find it as informative, educational, and value adding as I did and continue to do so! I should of added as I did in another post "except for small and simple projects. Excel is great for making personal logs and list that very few people will use and have limited amounts of records and fields.

I will also say excel is fine for creating very simple schedules. This I agree with, which my post probably did not convey. However, when a lot of people start using the same sheet, then you run into a whole host of problems.

Excel is only there to help one do your job better. My point is you need to look at the alternatives which includes total life cycle cost , creation time, and who will use the information. There is no point in recreating the wheel if there is software that cost a firm what they pay for 2 or 3 hours of your time.

This is an excellent series - and perfect for this situations where even though you have access to some fancy and more complicated software - once this is set up - it can be used as a template for those smaller projects like the ones I always seem to get Certainly we can all agree that there can be changes made to suite each of our needs - but that's the neat thing about it Having said that - Chandoo - I sent you and email to inquire about Pivot Table usage with regards to some portion of this Could you explain exactly how the legen sheet is used and what and where the link is between the two sheets.

And about the colours, I managed to change the colors related to the 'actual' element of the grid by selecting the entire grid and changing the font color, but how do I change the color linked to the 'planned' part of the grid - thanks for a great series! Hope that makes sense.

CS: legend sheet is used to define the symbols used in filling the gantt chart completion bars and labels for Planned and actual words. The color is same for both planned and actual.

You can edit these colors from conditional formatting dialog. Ben: I am using a variety of charts called as in-cell charts. That is why may be you are seeing bars in jumps. You can replace the in-cell charts with traditional bar charts so that you can get more fine grained bars Also, try with more duration than 2 days say 30 days and you should see bars of varying lengths.

How easy would it be to also incorporate a 'Budget' section showing a vertical bar chart presenting the target budget and actual costs incurred in implementing the project? It would be a nice addition to this or the dashboard template.

Infact you get a gantt chart template template 1 in the project management bundle that has a vertical bar chart showing activity completions. You can easily configure this to show budget vs. I realize this may be very basic but I cannot seem to figure out how to highlight the week column.

Some assistance please. Dear Chandoo, Today I started this Project Management Series but realized that even after reading Chandoo's blog I can't independently prepare Gantt chart as I say this because Chandoo is our hero and champion of novices and non-professionals like me and his blogs are not meant only for MVPs. Thanks and kind regards Fakhar. If the Plan changes, as long as you've followed a process to justify that change, I don't see the need to keep the original plan and then have a 'new plan', which I assume is what the Actual is being used for here.

Very good point. I have used Actual vs. Planned view as some times in projects even though plans change, managers and sponsors stick to original view and want to ask for justifications for schedule slippages.

I have seen this happen in several of the projects where I worked. If you follow agile methodologies or similar ideas in project management, this should not be a problem, otherwise you may want to have actual and planned view of gantt to find differences. We can use such a set up in, for eg. Gantt Charts to change the project start dates with ease.

Today we are going to learn how to set up automatic [ NET den plz tell me on my e--mail and u have any example of this den also send me Thank You A learning goldmine from the pointy haired dilbert. Love the chart, one thing; I'd like to change the "planned" and "actual" start days from weeks to days. How can this be done without breaking the formulas?? Make sure you have changed the numbers in top row to dates of successive weeks as well. It might take sometime to figure out how this works, but you should be able to do it easily without writing drastically new formulas.

Written on June 16th, last year, the post attracted k page views so far, with 63 comments. This is an excellent chart and am very impressed witht eh feaures, on question, I am a maintenance planner and use MSProject i see this as a bit of a step forward to me if it could schedule in hrs. We have a lot of daily shutdowns that i would like to schedule in a minimun on 30Minute units.

Do you think it would be poss to do??.. Fantastic chart! Thank you! But when I try to include this into another Excel book, the chart doesn't work propertly. Chandoo, is there any way to integrate this in a different Excel book? Hong: you can link to this page with an excerpt and a small image of the chart. I hope that is ok. Great series Chandoo I've bought the set and looking for some help to understand an issue I have run into My expectations are that 5 activities should be ongoing.

Activities with Activity 1 not being shown I've tried changing the Index calculation with no luck and tried understanding whether the Named lists are off, but to no avail Hi, may I know how do I apply the circular reference to have the highlighting of current week or day? Thanks again! Hi chandoo! What does your legends indicate? How do I show actual vs.

Hi, Great job! Do you have a version of the worksheet which displays in days rather than in weeks? Not much use for me. For me It is important to have dates showing, but I could not get that to work. I could not view the planned and actual at the same time, and I needed something that allowed me to compare how things were doing at a glance, and this does not allow it. I think if you go by weeks, then it will be OK, but for those of us that need to work to set dates and don't have the time to compare the week number to a calendar, then sorry, I don't see this being much use, sorry.

I loved the approach but have hit a wall. I am helping a friend implementing a gantt chart I have just downloaded your templates but she needs a cell per week, and in each cell the numbers of days worked in that week. The project is for a few years!. So the bars would go from one bar to 5 bars. I want to align them all so that it looks like a continuous bar with the bars in the first cell aligned to the right if there are less than 5, and the one at the end of the line aligned to the left if less than 5.

This cannot be done by conditional formatting as the alignment is not part of the conditional formatting tools I am using for that project, but checked , the alignment is also not a conditional formatting option. I then thought of adding spaces for the days that are not worked, either to the left or to the right using if in the formula.

The spaces do not have the same width as the font I tried. I'm sure there is an easy way but cannot see it! It is looking great what you are achieving with Excel but this one is limited at a certain point regarding project management. You can not handle working calendar and all king of scheduling mechanisms if you have these needs.

Thanks for all these great stuff. I made my own chart with planned and actual dates and colored it with conditional formatting. Now I am thinking how to highlight a date which crosses over two months example planned start date is from 28 April to 4 May. It does not work if I repeat dates after 31st for the next month. Please help. Making Excel work for everyone who has to work with it. Chandoo Gantt [ Does that make any sense Hi, I have quite some experience of project management, and would make the following comments.

For a large complex project you use Excel at your peril because you should first establish dependancies after you have identified the tasks, then assign resources and evaluate durations in real world calendars, however you can share your MS-Project with Excel users using Paste Link to distribute the calculating engine of MSP.

On one project I managed, we took 9 months out of a 3 year project by evaluating the critical path, and doing some re-structuring. Excellent that the capabilities of Excel are being shared, so keep it up. I apologize for the novice quesiton. When I download this gnatt chart it has only 32 columns for scheduling i. How can I increase that frame. I tried a lot but failed. Gantt charts are an excellent project management tool and the best thing about integrating them into Excel is that you don't have to learn or install any new software!

Hello Chandoo. Thank you for your Gantt Chart Project Template. I have try this, and do some modifications, but I have a problems: 1. Anyone managed to alter it so that when there is a value in the Actual Start column but the Actual Duration value is blank then this is still shown with blue between the actual start value and this weeks value? At the moment nothing is indicated. Hi Chandoo, I can never thank you enough on the gantt chart help and examples!

Singleton, M. Peirce, D. The Hot All Charts. All Charts. Datepicker Week of December 5, Info The Hot This week's most popular songs across all genres, ranked by radio airplay audience impressions, as measured by Nielsen Music, sales data as compiled by Nielsen Music, and streaming activity data provided by online music sources.

Stats Credits Awards Share. Last week 1. Weeks on chart Songwriter s : S. Robinson Producer s : Shux, J. The Hot This Week. Award i. Gains in Weekly Performance. Additional Awards click to see more.

Last Week. Peak Pos. Wks on Chart. Credits Awards Share. Songwriter s : N. Credits Share. Songwriter s : A. Young Producer s : A. Young, M. Songwriter s : J. Heap Producer s : J. Songwriter s : K. Levin Producer s : Dr. Thomas Producer s : J. Songwriter s : P.

Thiam Producer s : D. Fusari Producer s : R. Songwriter s : Max Martin, Shellback, T. Songwriter s : Jay Sean, J. Songwriter s : L. Cornish Producer s : Dr. Songwriter s : W. Chase Producer s : K. Harris, will. Songwriter s : B. Songwriter s : D. Kear Producer s : P. Songwriter s : T. Swift, L. Rose Producer s : N.

Chapman, T. Tedder Producer s : R. Songwriter s : M. Riesterer Producer s : D. Alatas Producer s : Ye, No I. Songwriter s : C. Followill Producer s : A. Petraglia, J. Nkhereanye Producer s : JB, C.

Mayer Producer s : J. Swift Producer s : N. Songwriter s : Y. Reuter Producer s : M. Reuter, Y. Caillat, R. Nowels Producer s : R. Songwriter s : R. Lewis Producer s : R. Songwriter s : Z. Mullins Producer s : K.

Stegall, Z. Haywood Producer s : J. Songwriter s : U. Tamburino Producer s : B. Cannon, K. Stewart Producer s : M. Diamond, M. Green Producer s : R. McEntire, M. Johnson Producer s : B.

Sheehan Producer s : S. Lambert, N. Hemby Producer s : F. Liddell, M. Franti, C. Young Producer s : M. Songwriter s : E. Bjorklund Producer s : M.

Automatically create historical quotes charts Posted days ago. How to download the history of dividend payments for stocks in the US market Posted days ago. Same chart, different symbols Posted days ago. Composite Indicators Posted days ago. Example of advanced rule Posted days ago.

Watch your support and resistance lines Posted days ago. Beta release Posted days ago.