New to excel 2007 gantt chart

I am struggling with excel 2007 gantt charting.. I have had enough problems with charts and graphs in 2003, OMG, here comes 2007 which is suppose to be easy.. yeah right... I am attaching a very small excel spreadhseet with just a little bit of data.. can someone PLEASE take this info and put it into a gantt chart so that I can learn from it and add to it... thank you so very much..
gantt-chart-example.xlsx
armymom13Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello armymom,

see the attached as a starting point.

Gantt charts can be created with stacked horizontal bars. The first series is the Opened date, the second series is the duration (= the difference between Due date and opened date)

The first series is set to no fill and no line, so it is invisible.

The X axis can be tweaked to show the first of the month only, but that will require a few tricks with more data series and an XY chart overlayed.

Please let me know if that is something you can work with.

gantt-chart-example.xlsx
0
armymom13Author Commented:
this looks really good, is there a way to show % complete? by adding a column and inputting my numbers? LIke the first issue is 49% completed.
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello armymom,

take 2 attached.

To show percentage complete, you need a few more columns. One to enter the percentage, another one to calculate how many days that represents, and a third one to calculate how many days are left til due date.

The stacked bars now contain the columns Opened, ccomplete and cduration.

I've added the percentage numbers as labels to the bars. This can not be done with native Excel functionality, but with a free tool called Chart Labeler, which can be downloaded here:
http://www.appspro.com/Utilities/ChartLabeler.htm

cheers, teylyn
gantt-chart-example.xlsx
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
armymom13Author Commented:
I love take 2, it does exactly what I want it to, and now I will study it, and learn how to do it myself... Thank you, and I will definitely download the tool... thanks Again...
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Thanks for the grade!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.