Chart XY TIME - Activities Like GANTT

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


ADVERTISEMENT

Time Table/ Gantt Chart

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

Holiday Calculation In Gantt Chart

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

Gantt Chart - Extra Condition

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

Automate Gantt Chart Creation

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

Create Gantt Or Timeline Chart

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

Date Formula - Gantt Chart View

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

Gantt Chart Help With Conditional Formatting Automation

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

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 View Related

Automatically Setting X Axis Value For Gantt Chart?

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

Automatic Gantt Chart Format Formula

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

Employee Scheduling Program Gantt Chart

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

Excel 2007 :: Gantt Or Stacked Bar Chart Timeline

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

Conditional Formatting Using Date Range (Gantt Chart)

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

Gantt Chart: Color Cells Dependent On Criteria

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

Gantt-type Chart With Quarterly Marks On The Date Axis?

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

Gantt Chart - Changing Cell Color Based On % Completed

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

Stopwatch- Activities

Feb 2, 2005

I tried out yjoshi's stopwatch, but when I open the stop watch (file was attached in that thread) it is not possible to work with other docs in Excel, and I also have trouble locating the VB code for the actons.

Therefore I am wondering if anyone have any solution on how to get the following:
I was thinking of a button in cell A1 named "Start", when clicked on start time ( date and time) will be inserted in first available column A.

Cell B1 contains a button called "Stop", clicked on will put time in column B and move the marker to cell Dx (x, being row number of the latest stop time.

Why D and not C? In column C I was thinking of a formula calculating the time and in column D I will fill in a short explanation what I did during the time.

View 8 Replies View Related

Excel 2010 :: Create Graph To Show Times Of Use For Particular Sporting Activities On Particular Days

Mar 20, 2014

Excel 2010 - I need to create a graph that shows a week's use of a sportsground showing what sports were played, on which days and between which times. I thought I could show the times on the vertical axis, days on the horizontal axis and then the sports played in those times, however I'm unsure as to how to get the graph to recognise the times.

I've attached an example of some data and how I'd like to see it, I'm just not sure how I can do this using the chart set up!

Attached File : Graphs.xlsx‎

View 10 Replies View Related

Basic Chart: Set A Chart Up With The Time Been On The X - Axis

Aug 1, 2007

I got a set of data which is only 2 colums collecting data problems. The output i get is a time stamp and a fault. Im looking to set a chart up with the time been on the X - axis and number of problems per hour on the Y - axis.

View 7 Replies View Related

Creating A Gantt Based On Values In Cells

Jul 9, 2008

Based on a Beginning Date Value and an Ending Date Value - I would like to color a range of Cells - the month (dates) are in the header row.

For example: Beginning Date = 01/01/09
Ending Date = 06/01/09

I want the range of cells in the same row colored orange under Jan '09 to June '09.

View 8 Replies View Related

1) Gantt Charts 2) Highlight Celles With A Click

Jan 16, 2010

As part of my work i am starting to create a two weekly programme in teh form of a gantt chart. now i have had a little google and seen plenty of spreadsheets available but they all seem to be not in a range of dates i would like. Ans plus they seem to be read only and thus i cant add a column on the end i would like for displaying resources used for the task.

Now i am sure if i searched hard enough i could find this answer but I have another question.

Whereas all the one i have seen involve typing the date and it just displays the bar.

Is there a way I can make it so that i can just click on a cell and that cell becaomes highlighted. so for example of o want at ask to happen on a wednesday i click the cell in that row and t automatically fills. and if i click it again it dissapears?

View 6 Replies View Related

Need To Chart Occurrences Over Time

Jan 16, 2014

I need to use excel on a daily basis at my new job and want to become more efficient.

7-Juntf
7-Junnon
8-Juntf
8-Junnon
8-Juntf
9-Junnon
9-Junnon
9-Junnon
9-Juntf
10-Junnon
11-Juntf
12-Junnon

This is a very simplified version of what I need to graph but has the variables I need. The spreadsheet is set up just like this, just extrapolated over the last year. There are over 500 entries in the spreadsheet. What I need to do is to be able to calculate and chart the number of occurrences of TF and Non over time, by day, month, and year. If the data is ordered by date, how can I get excel to calculate text occurrences and graph them over the dates?

View 2 Replies View Related

Chart Growing With Time

Sep 1, 2005

I have a large column of data that’s about 500 rows deep. I enter a few points of data a day. I want a simple bar graph to chart that data in order. Simple enough.

I set up the chart and everything. But after 2 days the chart is all scrunched up on the left side. And the remainder of the chart is considered 0. I want the chart to grow as I enter data without changing the data range every day

View 9 Replies View Related

Chart Time Summation

Apr 13, 2009

Currently I am trying to do a gantt like chart time summation. I'll try to explain this as clear as possible... Right now I have a program that finds the name of a part in a giant list's column and then copies a few of the other columns (priority and hours to complete) from the part names row and pastes them into a new sheet. I then sort all the found data by their priority number. The job that is gets sorted to the top is the next job to be worked on for the machine. So here is what I need to be able to do...

Based on the following example I need to be able to sum for the object bolt on Machine #1 the tenative date that the "bolt" will be completed by. It will take a minimum of 35 hours for the bolt to get off Machine #1 based on its current priority. However, the part: "bolt" needs to go to Machine #2 before being completed. The part will have to wait a hour for "hammer" before being started on machine 2. (Its data for the time it will take complete "bolt" on machine 2 is also stored in the spreadsheet.) Since the bolts priority is higher than the "nail"... the "bolt" will be the next job to be completed. My question is this: Is there a way to tenatively sum the future hours that it will take to complete the bolt and allow it to be open to changes, in case a higher priority part comes into the system?

Machine #1

PRIORITY HOURSNAME123nut212bolt334washer422kazoo

MACHINE #2

PRIORITY
HOURSNAME122screw22hammer31nail

View 9 Replies View Related

GANTT Charts To Display Multiple Entries Per Date

Jan 18, 2007

I'm trying to create a chart that will display dates along the vertical (y) axis and time (on a 24-hour timeline) on the horizontal (x) axis. Ideally, I'd like the chart to show the various time entries on each date, perhaps represented by a point or other mark at the appropriate intervals corresponding to the time entries for each date. Failing that, a Gantt-style chart that shows a span, represented by a bar beginning at the earliest time and extending to the latest time entry for each date would be useful....

View 9 Replies View Related

2 Series Chart For Different Time Periods

Oct 24, 2007

I am trying to plot two data series in one chart. The first series has monthly corn prices for last 10 years (~130 data points). The second series has bimonthly chicken prices over the last 10 years ( ~72 points). How can I plot them together?
The bi-monthly periods for the second series do not exactly coincide with calender months ( e.g. Aug 19 to Oct 13, 2007). As a result, I can not adjust the points to match with calender months.

View 2 Replies View Related

Count Conditional Format Color Cells- Used Gantt Code

Sep 3, 2004

I've created a Gantt chart using the tip #58. Now how can I count all the cells that are colored?

View 9 Replies View Related

Chart A Graph Of Jobs Over A Period Of Time

Jun 17, 2007

I have an Access database, with a table of jobs processed.

One column for Job ID (Unique), Date it was processed, By Who it was processed and Comments ascoiated.

I need to chart a graph of Jobs over a period of time. How many jobs done per date. In excel preferebly, I have programs like Database Plus for excel. And I am familiar with VBA. I can't figure out how to uniquely sort how many jobs for each date. As there are numerous job entries for on the same dates. I think it can be done with an SQL query or sorting it with VBA somehow. Any help will be greatly appreciated. Or can anyone suggest an application designed for charting with Access databases in Excel?

View 6 Replies View Related

Plot X Values At A Time In Dynamic Chart

Sep 26, 2007

I have over 5000 cells of data. I want to take 4 data points at a time, average them then plot them on a dynamic chart. I know how to do the dynamic chart but how can I take the average of the the first 4 numbers store it in a different cell, then the next 4 and so on...

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved