Gaant chart

RET79

Well-known Member
Joined
Mar 19, 2002
Messages
526
Hi.

I am trying to create a cool tool to create Gaant charts with minimum effort. I have seen an example of this from J.Walkenbach's excel bible, but I want to extend this with your help!

Esentially, I just want the user to specify the following:

Type of Job, Week starting (number or date or both), duration (weeks or days or both), who is assigned to do the job (initials).

I want to end up with:

week number and dates across the top as columns,

type of job listed down the side,

the people's initials printed on the center of the bars in the chart.

To take it even further, I would like to get an extra column, where one would specify % of work completed. For instance, for job no1 if the project is 80% complete, the user would type 80% in a column and 80% of the bar would be shaded in.

Not as easy as you may think....

RET79
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
http://www.j-walk.com/ss/excel/files/general.htm

is a link that will take you to downloadz for some cool Gaant charts he has available.

In addition to this I need:

1. some way of putting employees initials on each BAR to show it is them in charge of that particular task

2. some sort of input whereby you specify how much of the task is completed and the bar will be shaded accordingly.

RET79
 
Upvote 0
Hi,

You may find something that helps on Jon Peltier's website. Jon is *the* Excel chart master, although MrExcel himself seems to be able to give him a run for his money.

http://www.geocities.com/jonpeltier/index.html

Tushar Mehta's site has a Gantt chart example which may be of use.

Neither has the specific answers for you, but you might learn how to do it with their examples.

Bye,
Jay

P.S. How did the calculus file work for you?
 
Upvote 0
Jay,

I just had a brief look at the calculus thing and it looks AWESOME. I do not pretend to understand how the coding all works but it has certainly opened my mind to what excel can do.

WOW!!!

RET79

PS Thanks for the Gaant tip
 
Upvote 0
<TABLE border=1 borderColor=#000000 cellPadding=1 cellSpacing=1>
<TBODY>
<TR>
<TD> Job</TD>
<TD> Initials</TD>
<TD> Amount done</TD>
<TD>Amount left </TD></TR>
<TR>
<TD> A</TD>
<TD> RET</TD>
<TD> 3380</TD>
<TD> 845</TD></TR>
<TR>
<TD>B </TD>
<TD> RET/RB</TD>
<TD> 4121</TD>
<TD> 1232</TD></TR>
<TR>
<TD> C</TD>
<TD> JPS/RET</TD>
<TD> 825</TD>
<TD> 1600</TD></TR>
<TR>
<TD> D</TD>
<TD> ECM</TD>
<TD> 5045</TD>
<TD> 1433</TD></TR></TBODY></TABLE>
 
Upvote 0
OK, this is my basic problem.

With the table above, select it all, go to chart wizard, choose bar, then choose the one to the right of the default one (stacked bar).

Click next.

Now, what I get is the data is ok, but, both the ABCDE and the Initials are on the vertical axis.

What I want is for the A,B,C,D,E to stay on the axis, but for the initials RET, RET/RTB etc. to be put ON the bar!!

Now, I have ALMOST got this, if you go to step 3 of the wizard, click the data labels tab and then click the 'show labels' option button then it will put ABCDE, RET RET/RB etc. ON the bars like I want. BUT what I want is for JUST the initials on the bar and just the ABCDE on the vertical axis !!!!

I hope I am making any sense, any help appreciated so much...

RET79
 
Upvote 0
I'm not that experienced with the finer points of Excel charting, but here is my offering...

1. Interchange the Job and Initials columns, and only use the last three columns for your source data. You'll have the initials alone on the Y-axis and your data remains as before.

2. Create a text box on the resulting chart and place it in the area of the first bar. Format as desired.

3. In the formula bar at the top, type an = sign and then click on the cell that says "RET"

4. Repeat for the other bars.

Bye,
Jay
 
Upvote 0
Anyway, I am going to approach this thing in a different way now, ignoring the charts, and just putting the thing on a spreadsheet as it is currently.

Jay, if you're interested I could send you this small spreadsheet showing what I want to get automated. You may/may not agree that doing a macro to create it would be better than charting the thing.

RET79
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top