Gantt Chart Independent Cell Widths
May 28, 2014
I am developing a Excel gantt chat i have chosen to display the bars by the lenght of the cell because the data is also most real time so as the time reduces so will the bars however the problem comes when there is tasks being done under one above it as i cant have the cells with different widths
What would be the best way to get around it as i want to keep the almost and the appearance of the real time nature of the cell width equal to the value.
View 2 Replies
ADVERTISEMENT
Oct 3, 2007
For the past 4 months I have been desperate to find a way to split my sheet so that I can determine the column widths above and below that point independently.
For example:
small width from a1-b1
but
really large width from a2-b2
Is there a way to do that?
View 9 Replies
View Related
Aug 12, 2014
I'm trying to create a simplified Gantt chart of sorts, and cannot figure out one piece of it. I'm not sure how to write out exactly what I need, but here goes.
I would like to have a formula that looks at the percent completed (which the user inputs) and multiplies it by the total duration for the task to give a total number of days completed. Then, under the corresponding dates, the color of the cell would change. I've attached a simplified version of what I'm talking about.
On the attached spreadsheet, the total duration (D2) is 5 days and the percent completed (C2) is 40%. This calculates to 2 days. With that said, I would like the cells under the first 2 days under the listed dates (E2 and F2) to change color. When the percentage complete reaches 60%, then G2 would change color, when it reaches 80%, then H2 would change, and when it reaches 100%, then I2 would change.
My guess is that the formula will need to result in a particular value, and then I'll use Conditional Formatting to do the actual changing of the cell color. Assuming this is correct, I still don't know what formula to use to accomplish this.
View 7 Replies
View Related
Jan 2, 2009
Let's suppose that I have a serie of activities. All activities are done in an interval of time and there is not overlapping.
View 14 Replies
View Related
Jul 8, 2014
Gantt chart to calculate holidays, it now only calculation weekends only, file can be downloaded from here.
View 2 Replies
View Related
Dec 15, 2008
The below is a sample Gantt chart that I'm using, it's working fine, what I want to do is when the STATUS is completed (Column H) goes from a cross to a tick (I'm using the format of Wingdings 2 - cross is O and tick is P) is to change the Gantt chart colour from it's current colour of green to say orange. In conditional formatting (in cell I3) I have, formula is =AND(I$2>=$F3,I$2
View 9 Replies
View Related
Oct 25, 2009
Hi guys, I would like to be able to automatically gantt chart the following data table, my problem is that i am unaware of how to create the gantt chart when there are several entries for the one location - the table is a booking sheet and the gantt chart is just a graphical display of the activity occuring in each bay - if any could help me achieve the following gantt chart from the the following table it would be much appreciated: ...
View 9 Replies
View Related
Nov 7, 2006
I am trying to find a way to automate this crude gant chart. What I am trying to do is the following:
1: By entering a start date and due date, and by adding a percentage to 4 different goals, create a sort of gant chart for each job.
2: Have this chart update as the start and due dates change.
3: Be able to past other gant charts below this one, based on the leader assigned to each job. ie. if Dave is a leader, create a worksheet that will have all of dave's Gant charts in one workbook, on one worksheet, pasted each one below the next. The goal being we can give each leader 1 sheet that has all their jobs.
View 6 Replies
View Related
Jul 1, 2008
I tried so long I finally gave up and drew this by hand in MS Word:
But I wonder if you guys could help me chart this automatical in Excel.
I want to chart the time period a ship (Vela, Serpentine, Rainbow etc) are contracted. I want a specific color for the firm contract, and another for the remaining optional contract. If a ship is under construction I also want a bar showing when it's done.
Each ship has a rate. I want this written on the bar. In "Vela's" case there are to rates for the same contract: The first 740 days the rate is 24,5 the rest of the period it is 29. I also would like to be able plot an additional contract for the same ship for example after "Syrena" is done in yr 2009.
View 9 Replies
View Related
Jan 22, 2014
Someone else built a this timeline using a date calculation that I am unable to modify. Fix date formula in row 7 to show FY14-FY18 and in row 7 show the quarters 1-4 along the years.
View 3 Replies
View Related
Dec 14, 2009
Hey Guys- I'm not sure if this is even possible but I need some help. I have attached a file below similar to a gantt chart. I need help with the conditional formatting, as I have manually changed the colors to match what I need automated.
Basically I have 6 tasks and I need to change dates for individual projects but I also need the corresponding color to also change.
View 9 Replies
View Related
Sep 26, 2013
I have created a pseudo Gantt chart in Excel (a horizontal stacked bar chart). The chart is driven off data I have in a Power Pivot model (Auto Refreshed) and the Gantt chart displays data which spans a fixed 12 hour time frame.
The problem I am having is that in order for me to get the chart to display correctly I must manually (daily) get the excel decimal values for my Minimum DateTime and Maximum DateTime and then enter those numbers into the "AXIS Options" Bounds Minimum and Maximum value fields. I would like to automate that process so that the Axis Bounds are either driven from the data cells OR are always set to a specific 12 hour window 6pm->6am daily.
View 1 Replies
View Related
Sep 16, 2008
I am looking to create a spreadheet that will automatically shade blocks in a gannt chart according to a list of dates.
I.e B13 & B14 will have the start and end date of the particular task or activity (this will be on another sheet)
Row A3 - S3 will contain dates, iusing a lookup formulas excel will look up the activity name (or number) and look for the relevant date, if the date listed in row 3 is within or equal to that date it will return yes, if not a no.
this seemed straightforad, but I cant think of a consistent formula that will do this, without having to keep changing it ...
View 19 Replies
View Related
Feb 14, 2007
I'm trying to create an Employee Scheduler. I want my employees (1 technician per row for a total of 10 rows) in the 1st column then the monthly calendar to the right (1 cell/day). That is what you'll see when you open the worksheet. Then, down below I set up my Data Area where I input my project, start date, end date, technician (where each tech is assigned a unique number), and other data across a row of cells. This could be infinite (or at least up to the very last row).
I modified a free Project Scheduler I got from XL-EasyGantt to become my Employee Scheduler but am having some difficulties getting it to do what I want. The project Scheduler basically works by entering (on the same row) the project (or task), the start date and finish date and then the cells get automatically filled in across those dates. This allows for overlapping of tasks but I want to create an Employee Scheduler so it doesn't allow overlapping or schedule a technician to start a new project before he/she has completed the one their on.
The main function which is in each cell of the monthly calendar is as follows: =IF(OR(AND($G28>=K$4,$G28<L$4),AND($M28>=K$4,K$4>=$G28)),IF(AND($E11="x",$M28>=K$4,$M28<L$4),"x",IF($E11=".",".","..")),"")
My problem: I want to be able to look at the Main Schedule and see when each Technician is scheduled for a job (or multiple jobs) for any given month. I want the function to look in my Data Area and assign the start date and end date of a project and the corresponding technician number and fill in the date cells across from their name in the Schedule above.
View 6 Replies
View Related
Jan 24, 2014
I can automate chart creation in VBA, but is there any way to also have it such that the x-axis of the chart begins with the minimum x-value and ends with the maximum x-value in the data set?
View 2 Replies
View Related
Mar 19, 2012
I'm attempting to chart data obtained from our phone system to see when users are logged in/on rest.
I'm using Excel 2007.
The data we extract has:
person | status | start | finish | duration
Status is either "login" or "rest"
Start/finish is time (h:mm)
Duration is a formula (h:mm, finish - start)
I want to have a stacked bar chart that shows when a person was logged in/on rest; one bar for each person.
x-axis: person
y-axis: time (8am - 6pm)
legend: status
The problem I'm encountering is that each person logs in and out multiple times throughout the day (therefore, has multiple lines to their name in the data), and I can't get this information to appear on a single bar for each person.
I've sorted the data into a pivot table which gives me the information I want, but how to get the chart.
Row labels
a. Person
b. status
c. start
Values
Min of duration
Ideally, I would like to avoid using a Gantt chart within cells (as it would involve vlookup/if statements), but am beginning to think that's my only option...
View 3 Replies
View Related
Jun 16, 2014
I am looking for the best way to use conditional formatting in a Gantt chart. I want the cells to turn blue if they fall between two dates.
View 4 Replies
View Related
Dec 5, 2006
I have a list of task owners that are assigned tasks. The tasks are mapped out in Gantt chart form with time shown by an "X".
what I want to do is to colour the cells "X" with the associated cell colour of the task owner and should the owner change, the cell colour changes.
View 5 Replies
View Related
May 22, 2014
I'm using a stacked bar chart (in Excel 2010, running on Windows 7) to create a simple Gantt-type chart - with just four or five bars. I've got my chart looking most of the way I want it to, but one thing still eludes me: I'd like to set up the major axis ticks to be quarters of the year (from 1/1/2011 to 4/1/2013). Since quarters are not regular intervals (they are not exactly every 90 days), I can't do this using Excel's standard functionality for choosing axis tick marks.
View 3 Replies
View Related
Oct 20, 2013
I'm trying to set up a dependent cell (B) based on what is in the independent cell (A)
If A is blank, B should be blank
If A has any value other than X, B should display a set string Y
If A contains X, B should contain a drop down list with a range of choices.
I've tried setting it up as a dependent validation cell and I've tried using OFFSET, but the best I can do is to get three different drop down lists to populate cell B. One with only string Y, one with only a blank, and one with the range of choices. The problem is in the first two cases above, I want the cell to fill automatically with either blank or string Y -- I don't want them to just be drop down options, with the cell displaying the last value that was input.
View 2 Replies
View Related
Nov 9, 2007
I have one table with 0.5" cell widths. Good.
I have another table with 1.875" cell widths. Good.
I want both tables on the same page, one under the other. Hard.
How can I achieve this? Is there a way to have the column widths of one table independent of the other on the same page? Is there a workaround that would achieve the same effect?
View 9 Replies
View Related
Jul 27, 2007
I would like to know if it's possible to change width of different cells in a single column? Example:
Width of cell A1 would be 10, and width of cell A2 would be 15. Can it be done? If yes how, if no damn. The reason I ask is because I trying to fit a report on one page with a chart and a month worth of data, but some cells are to long and they get cut off.
View 3 Replies
View Related
Jul 20, 2006
Is there any way to measure the width of text in a cell in points? I know that the width of the cell is returned using the Width property.
I also know that the number of characters in the text can be returned using the LEN() function, but I don't believe the number of characters can be converted to points (because some characters are different widths, if I'm not mistaken)
View 9 Replies
View Related
Aug 1, 2012
Is it possible to create independent filters. I have data for five departments and sales for different quarters of the years. These sales for the different quarters are independent. But If I select Q1 for first department and Q2 for second department it do not give me the result that I seek i.e. sales for first department for Q1 and Sales for second department for Q2.
View 9 Replies
View Related
Jun 30, 2008
If the issue is not immediately clear:
If I select, for example, columns B:E and group (Data -> group and outline -> group). These can be hidden/unhidden easily with the line and + button created in the process. A similar set of columns (e.g. P:S) will behave in exactly the same way. If I have grouped columns B:E however and then try to group F:H, I end up with one large group spanning B:H.
If it is possible to create these 'separate' or 'independent' adjacent groups, I'd love to know how; if not, I'd be interested to know if anyone else has found this irritating
View 3 Replies
View Related
Dec 29, 2011
How can I make the files path independent. Lets say I have 6 workbooks, one of them having macro that connects all the six books. While working on my pc, I entered the file locations by myself. The macro runs fine.
Now I have to send the files to someone and would not like them to add their download directory at most places in the code. I want that after downloading, they have to only open the main file and press the button to run macro. How should I do that.
Right now am using this approach:-
sub main{
str 1file;
set 1file = Workbooks.Open ("c:/downloads...../1stfile.xls")
and similar code for calling other files.
View 2 Replies
View Related
Apr 1, 2012
I have two spreadsheets which carry the same information in three cells. Instead of just placing a link, =B2 etc., I would like to have the cells linked to each other through code.
For the one sheet I can use this with no problem, but as soon as I place this worksheet change event in the other sheet but reverse the cells references Excel gets unhappy.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
Set rng = Target.Parent.Range("B2, M2, N2")
[Code]....
Any proper way to update a cell no matter which spreadsheet the change takes place?
Sheet1 >> change is made to cell B2 and that same value is applied to Sheet cell C4.
View 3 Replies
View Related
Feb 4, 2010
I need a macro that can autofill irrespective of where the source cells are. Like, this is what I want to do:
Select two cells containing a descending order such as 50, 40. Hit the hotkey and the macro should autofill the same way as double clicking the bottom right corner of the selection.
The problem is that the two source cells can be anywhere in the sheet, and autofill range isn't fixed. Essentially, I just want a keyboard shortcut for Excel's own Autofill function.
I want this macro to be rid of the mouse when I'm working on excel (it really slows me down to use the mouse every time I want to autofill).
View 9 Replies
View Related
Aug 22, 2006
I am working with two tables in one sheet. The first table requires seven columns. Under this table, i want to have another table that has 14 columns right under it so that their widths are the same. Is this possible? It would be like having two sheets in one.
View 2 Replies
View Related
May 22, 2007
In the attached spread sheet, i have two set of data, for two different months.Columns A to D have the value for the first month and columns F to I have the values for the second month. In the first set of Values i have the dollar value in the column "D" and in the second set of values i have the dollar value in column "F".
I want a macro, to compare these two cells and arrange the data accordingly. If both the values are the same, then both the lines corresponding to the values can remain in the same row. If one value is greater that other, then the set of values which have the lower dollar value should come to the next row. I have attachec the sample data. The lines highlighted in green is the raw data and the one in yellow is the finished data.
View 9 Replies
View Related
