Gantt Chart Troubles

natheplas

Board Regular
Joined
Aug 28, 2016
Messages
97
Hi All,

I was hoping someone can help me with a Gantt chart I've made. I want the dates at the top to be from the dates the project is starting to finishing. However, they don't match my start date columns and then when I plot the remaining duration date it doesn't correlate to the project dates.

This is harder to explain and easier to see.

I've spent hours trying to work out what I am doing wrong?!

If I'm able to send it to someone on here somehow to have a look that would be really good.

I hope someone can help me and many thanks in advance!

Kind Regards,

Nathan
 
Last edited:

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Are you using a stacked bar chart? If not then it won't really work.

Then you have two data sets, your 'start date' and your 'duration' as your sources. Both of these sources plotted on the same axis, both against the same source (like your activity title for example).
 
Upvote 0
Hi PostTIT,

Yeah i am using a stacked bar chart.

I do have them as two data sets, start date and remaining duration, plotted on the same axis, against the same source.

Not sure why it's not working as I want it to/should.

It's probably something really basic, I just can't see it!
 
Upvote 0
A few pitfalls I fell into when I made my Gantt chart (whether they help I don't know):

- Your two data sets shouldn't include the titles of their respective columns and should just be the dates/values alone.
- 'Start Date' should be your first data source.
- 'Duration' should be the second - if it is the other way around ('Duration' as the first set) it wont work at all
- The axis on the chart should be in date format (right click, format axis, menu on the right appears and change it in there)
- Click on the 'Select Data' button in the chart design tab, 'Start Date' and 'Duration' should appear on the left table, the individual items from the 'Activity' list should appear on the right.
 
Upvote 0
Hi,

I've checked all these and it's all as it should be.

Thanks for coming back to me though. So frustrating being beaten by a chart!!
 
Upvote 0
That's alright, just trying to help.

How have you set up your sheet? Table of data on the left and Gantt on the right? And what does your table look like?
 
Upvote 0
When you reply click 'Go advanced' and you can ctrl C and ctrl V your table into the reply box, or you can send a picture/screenshot of your worksheet. And then we can go from there.
 
Upvote 0
[TABLE="width: 2160"]
<colgroup><col width="64" style="width:48pt"> <col width="492" style="width:369pt"> <col width="283" style="width:212pt"> <col width="162" style="width:122pt"> <col width="138" style="width:104pt"> <col width="115" style="width:86pt"> <col width="175" style="width:131pt"> <col width="184" style="width:138pt"> <col width="115" style="width:86pt"> <col width="201" style="width:151pt"> <col width="148" style="width:111pt"> <col width="83" style="width:62pt"> </colgroup><tbody>[TR]
[TD="class: xl20, width: 64"]Item No.[/TD]
[TD="class: xl20, width: 492"]Task/Event[/TD]
[TD="class: xl20, width: 283"]Resource Names[/TD]
[TD="class: xl29, width: 162"]Original Duration[/TD]
[TD="class: xl29, width: 138"]Start Date[/TD]
[TD="class: xl29, width: 115"]Finish Date[/TD]
[TD="class: xl29, width: 175"]Duration Complete[/TD]
[TD="class: xl29, width: 184"]Remaining Duration[/TD]
[TD="class: xl29, width: 115"]%Complete[/TD]
[TD="class: xl29, width: 201"]Budgeted Labor Days[/TD]
[TD="class: xl29, width: 148"]Cumulitve Days[/TD]
[TD="class: xl29, width: 83"]% Cum[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Business Analysis/Project Kick Off Meeting[/TD]
[TD]SB, LC, NW, AR, RF, MC, MD, TP, PW, [/TD]
[TD="class: xl25"]2[/TD]
[TD="class: xl25"]22 February 2017[/TD]
[TD="class: xl25"]23-Feb-17[/TD]
[TD="class: xl25"]2[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl27"]100%[/TD]
[TD="class: xl25"]2[/TD]
[TD="class: xl25"]2[/TD]
[TD="class: xl28"]0.9%[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Project Documentation[/TD]
[TD]SB[/TD]
[TD="class: xl25"]60[/TD]
[TD="class: xl25"]02 March 2017[/TD]
[TD="class: xl25"]24-May-17[/TD]
[TD="class: xl25"]60[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl27"]100%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]3[/TD]
[TD="class: xl28"]1.4%[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Sage 50 data extract[/TD]
[TD]SB[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]05 May 2017[/TD]
[TD="class: xl25"]07-May-17[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl27"]100%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]4[/TD]
[TD="class: xl28"]1.9%[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]Run through Import templates & COA consultancy[/TD]
[TD]SB, LC, NW[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]08 May 2017[/TD]
[TD="class: xl25"]08-May-17[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl27"]100%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]5[/TD]
[TD="class: xl28"]2.3%[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Static Data Preparation in Excel[/TD]
[TD]NW[/TD]
[TD="class: xl25"]87[/TD]
[TD="class: xl25"]09 May 2017[/TD]
[TD="class: xl25"]06-Sep-17[/TD]
[TD="class: xl25"]17.4[/TD]
[TD="class: xl25"]69.6[/TD]
[TD="class: xl27"]20%[/TD]
[TD="class: xl25"]60[/TD]
[TD="class: xl25"]65[/TD]
[TD="class: xl28"]30.2%[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]BOM Static Data Preparation in Sage 50 Manufacturing[/TD]
[TD]NW[/TD]
[TD="class: xl25"]87[/TD]
[TD="class: xl25"]09 May 2017[/TD]
[TD="class: xl25"]06-Sep-17[/TD]
[TD="class: xl25"]17.4[/TD]
[TD="class: xl25"]69.6[/TD]
[TD="class: xl27"]20%[/TD]
[TD="class: xl25"]60[/TD]
[TD="class: xl25"]125[/TD]
[TD="class: xl28"]58.1%[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]Install Sage 200 & SQL Server on new server(s)[/TD]
[TD]PF[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]11 May 2017[/TD]
[TD="class: xl25"]11-May-17[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl27"]100%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]126[/TD]
[TD="class: xl28"]58.6%[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]Install, Configure and Train Spindle Document Distribution[/TD]
[TD]SB, LC, NW[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]15 May 2017[/TD]
[TD="class: xl25"]15-May-17[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl27"]100%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]127[/TD]
[TD="class: xl28"]59.1%[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD]Bespoke[/TD]
[TD]JM[/TD]
[TD="class: xl25"]4[/TD]
[TD="class: xl25"]12 June 2017[/TD]
[TD="class: xl25"]15-Jun-17[/TD]
[TD="class: xl25"]4[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl27"]100%[/TD]
[TD="class: xl25"]4[/TD]
[TD="class: xl25"]131[/TD]
[TD="class: xl28"]60.9%[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]Bespoke[/TD]
[TD]JM[/TD]
[TD="class: xl25"]4[/TD]
[TD="class: xl25"]26 June 2017[/TD]
[TD="class: xl25"]29-Jun-17[/TD]
[TD="class: xl25"]4[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl27"]100%[/TD]
[TD="class: xl25"]4[/TD]
[TD="class: xl25"]135[/TD]
[TD="class: xl28"]62.8%[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]User Training - Report Designer Part 1[/TD]
[TD]SB, LC, NW, LM[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]22 May 2017[/TD]
[TD="class: xl25"]21-May-17[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl27"]100%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]136[/TD]
[TD="class: xl28"]63.3%[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD]User Training - Report Designer Part 2[/TD]
[TD]SB, LC, NW, LM[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]23 May 2017[/TD]
[TD="class: xl25"]22-May-17[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl27"]100%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]137[/TD]
[TD="class: xl28"]63.7%[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD]Verplas to provide CIM: BOM data setup for all items in 50 Manufacturing[/TD]
[TD]NW[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]01 August 2017[/TD]
[TD="class: xl25"]01-Aug-17[/TD]
[TD="class: xl25"]0.2[/TD]
[TD="class: xl25"]0.8[/TD]
[TD="class: xl27"]20%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]138[/TD]
[TD="class: xl28"]64.2%[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]Data Extract – Bill of Materials[/TD]
[TD]NW[/TD]
[TD="class: xl25"]8[/TD]
[TD="class: xl25"]01 August 2017[/TD]
[TD="class: xl25"]10-Aug-17[/TD]
[TD="class: xl25"]1.6[/TD]
[TD="class: xl25"]6.4[/TD]
[TD="class: xl27"]20%[/TD]
[TD="class: xl25"]8[/TD]
[TD="class: xl25"]146[/TD]
[TD="class: xl28"]67.9%[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD]Bill of Materials Import template run through[/TD]
[TD]SB[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]01 August 2017[/TD]
[TD="class: xl25"]31-Jul-17[/TD]
[TD="class: xl25"]0.1[/TD]
[TD="class: xl25"]0.4[/TD]
[TD="class: xl27"]20%[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]146.5[/TD]
[TD="class: xl28"]68.1%[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD]Verplas to provide CIM: Cleansed Static Data Imports in Excel[/TD]
[TD]SB, NW[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]07 September 2017[/TD]
[TD="class: xl25"]06-Sep-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]147[/TD]
[TD="class: xl28"]68.4%[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD]Static Data import[/TD]
[TD]SB[/TD]
[TD="class: xl25"]2[/TD]
[TD="class: xl25"]11 September 2017[/TD]
[TD="class: xl25"]12-Sep-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]2[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]2[/TD]
[TD="class: xl25"]149[/TD]
[TD="class: xl28"]69.3%[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD]User Training – Nominal Ledger and Cash Book[/TD]
[TD]SB, LC, KR, CK, NW, AR, RF[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]21 September 2017[/TD]
[TD="class: xl25"]21-Sep-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]150[/TD]
[TD="class: xl28"]69.8%[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD]User Training – Stock Control session #1[/TD]
[TD]SB, NW, TP, RF, BG, MC[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]25 September 2017[/TD]
[TD="class: xl25"]25-Sep-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]151[/TD]
[TD="class: xl28"]70.2%[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]User Training – Sales Ledger and Purchase Ledger[/TD]
[TD]SB, NW, AR, MD, LC, CK, KR[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]26 September 2017[/TD]
[TD="class: xl25"]26-Sep-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]152[/TD]
[TD="class: xl28"]70.7%[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD]User Training – Stock Control session #2[/TD]
[TD]SB, MD, LC, SW, CT[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]27 September 2017[/TD]
[TD="class: xl25"]27-Sep-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]153[/TD]
[TD="class: xl28"]71.2%[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD]User Training – Sales Orders session #1[/TD]
[TD]SB, NW, RH, LM, LC, JM[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]03 October 2017[/TD]
[TD="class: xl25"]02-Oct-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]154[/TD]
[TD="class: xl28"]71.6%[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD]User Training – Sales Orders session #2[/TD]
[TD]SB, LW, ZM, MC, RF[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]03 October 2017[/TD]
[TD="class: xl25"]02-Oct-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]155[/TD]
[TD="class: xl28"]72.1%[/TD]
[/TR]
[TR]
[TD="align: right"]24[/TD]
[TD]User Training – SOP Despatch[/TD]
[TD]SB, NW, LC, PW, DA, JC, TP[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]04 October 2017[/TD]
[TD="class: xl25"]03-Oct-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]155.5[/TD]
[TD="class: xl28"]72.3%[/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD]User Training – Purchase Orders[/TD]
[TD]SB, LC, RF, NW, MD, PN[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]10 October 2017[/TD]
[TD="class: xl25"]10-Oct-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]156.5[/TD]
[TD="class: xl28"]72.8%[/TD]
[/TR]
[TR]
[TD="align: right"]26[/TD]
[TD]User Training – Bill of Materials[/TD]
[TD]SB, NW, MD, RF, BG, MP, LC[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]11 October 2017[/TD]
[TD="class: xl25"]11-Oct-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]157.5[/TD]
[TD="class: xl28"]73.3%[/TD]
[/TR]
[TR]
[TD="align: right"]27[/TD]
[TD]User Training – Works Orders session #1[/TD]
[TD]SB, NW, EH, GG, BG, CT, MS[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]16 October 2017[/TD]
[TD="class: xl25"]15-Oct-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1.5[/TD]
[TD="class: xl25"]159[/TD]
[TD="class: xl28"]74.0%[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD]User Training – Works Orders session #2[/TD]
[TD]SB, LC, RF, ME, JE, JM, JE[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]17 October 2017[/TD]
[TD="class: xl25"]16-Oct-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]159.5[/TD]
[TD="class: xl28"]74.2%[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD]User Training – Planning[/TD]
[TD]SB, NW, MD, BG, MP, LC[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]17 October 2017[/TD]
[TD="class: xl25"]16-Oct-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]160[/TD]
[TD="class: xl28"]74.4%[/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD]User Training – System Administration[/TD]
[TD]SB, NW, LC[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]18 October 2017[/TD]
[TD="class: xl25"]17-Oct-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]160.5[/TD]
[TD="class: xl28"]74.7%[/TD]
[/TR]
[TR]
[TD="align: right"]31[/TD]
[TD]User Training – Technical[/TD]
[TD]SB, NW[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]18 October 2017[/TD]
[TD="class: xl25"]17-Oct-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]0.5[/TD]
[TD="class: xl25"]161[/TD]
[TD="class: xl28"]74.9%[/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD]Test Phase[/TD]
[TD]Verplas[/TD]
[TD="class: xl25"]45[/TD]
[TD="class: xl25"]02 October 2017[/TD]
[TD="class: xl25"]03-Dec-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]45[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]45[/TD]
[TD="class: xl25"]206[/TD]
[TD="class: xl28"]95.8%[/TD]
[/TR]
[TR]
[TD="align: right"]33[/TD]
[TD]Verplas to report any queries/issues to CIM post Testing[/TD]
[TD]Verplas[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]04 December 2017[/TD]
[TD="class: xl25"]04-Dec-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]207[/TD]
[TD="class: xl28"]96.3%[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD]Pre-Go-Live Consultancy[/TD]
[TD]SB, NW, LC[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]11 December 2017[/TD]
[TD="class: xl25"]11-Dec-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]208[/TD]
[TD="class: xl28"]96.7%[/TD]
[/TR]
[TR]
[TD="align: right"]35[/TD]
[TD]Agreement to go live (Before Christmas)[/TD]
[TD]SB, NW, LC[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]11 December 2017[/TD]
[TD="class: xl25"]11-Dec-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]209[/TD]
[TD="class: xl28"]97.2%[/TD]
[/TR]
[TR]
[TD="align: right"]36[/TD]
[TD]Go-Live – Import Opening Balances, Client Installs (if applicable)[/TD]
[TD]SB, NW, LC[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]20 December 2017[/TD]
[TD="class: xl25"]20-Dec-17[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]210[/TD]
[TD="class: xl28"]97.7%[/TD]
[/TR]
[TR]
[TD="align: right"]37[/TD]
[TD]Go-Live – Import Opening Balances, Client Installs (if applicable)[/TD]
[TD]SB, NW, LC[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]03 January 2018[/TD]
[TD="class: xl25"]03-Jan-18[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]211[/TD]
[TD="class: xl28"]98.1%[/TD]
[/TR]
[TR]
[TD="align: right"]38[/TD]
[TD]Go Live – Handholding[/TD]
[TD]SB, Verplas[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]04 January 2018[/TD]
[TD="class: xl25"]04-Jan-18[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]212[/TD]
[TD="class: xl28"]98.6%[/TD]
[/TR]
[TR]
[TD="align: right"]39[/TD]
[TD]Implementation Snagging[/TD]
[TD]NW, LC, SB[/TD]
[TD="class: xl25"]2[/TD]
[TD="class: xl25"]08 January 2018[/TD]
[TD="class: xl25"]09-Jan-18[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]2[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]2[/TD]
[TD="class: xl25"]214[/TD]
[TD="class: xl28"]99.5%[/TD]
[/TR]
[TR]
[TD="align: right"]40[/TD]
[TD]Business Intelligence Setup and Training[/TD]
[TD]LC, NW, LM[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]01 February 2018[/TD]
[TD="class: xl25"]01-Feb-18[/TD]
[TD="class: xl25"]0[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl27"]0%[/TD]
[TD="class: xl25"]1[/TD]
[TD="class: xl25"]215[/TD]
[TD="class: xl28"]100.0%[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Here's the data behind the chart, I'm not sure how to paste just images of the gantt chart and data source?
 
Upvote 0

Forum statistics

Threads
1,223,897
Messages
6,175,271
Members
452,628
Latest member
dd2

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