Gantt Chart Troubles

natheplas

Board Regular
Joined
Aug 28, 2016
Messages
89
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:

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

PostTIT

Board Regular
Joined
Aug 22, 2016
Messages
94
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).
 

natheplas

Board Regular
Joined
Aug 28, 2016
Messages
89
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!
 

PostTIT

Board Regular
Joined
Aug 22, 2016
Messages
94
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.
 

natheplas

Board Regular
Joined
Aug 28, 2016
Messages
89

ADVERTISEMENT

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!!
 

PostTIT

Board Regular
Joined
Aug 22, 2016
Messages
94
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?
 

natheplas

Board Regular
Joined
Aug 28, 2016
Messages
89

ADVERTISEMENT

Hi,

Can you send worksheets on this? Be easier to show you than write it out.

Thanks.
 

PostTIT

Board Regular
Joined
Aug 22, 2016
Messages
94
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.
 

natheplas

Board Regular
Joined
Aug 28, 2016
Messages
89
Item No.Task/EventResource NamesOriginal DurationStart DateFinish DateDuration CompleteRemaining Duration%CompleteBudgeted Labor DaysCumulitve Days% Cum
1Business Analysis/Project Kick Off MeetingSB, LC, NW, AR, RF, MC, MD, TP, PW, 222 February 201723-Feb-1720100%220.9%
2Project DocumentationSB6002 March 201724-May-17600100%131.4%
3Sage 50 data extractSB105 May 201707-May-1710100%141.9%
4Run through Import templates & COA consultancySB, LC, NW108 May 201708-May-1710100%152.3%
5Static Data Preparation in ExcelNW8709 May 201706-Sep-1717.469.620%606530.2%
6BOM Static Data Preparation in Sage 50 ManufacturingNW8709 May 201706-Sep-1717.469.620%6012558.1%
7Install Sage 200 & SQL Server on new server(s)PF111 May 201711-May-1710100%112658.6%
8Install, Configure and Train Spindle Document DistributionSB, LC, NW115 May 201715-May-1710100%112759.1%
9BespokeJM412 June 201715-Jun-1740100%413160.9%
10BespokeJM426 June 201729-Jun-1740100%413562.8%
11User Training - Report Designer Part 1SB, LC, NW, LM0.522 May 201721-May-170.50100%113663.3%
12User Training - Report Designer Part 2SB, LC, NW, LM0.523 May 201722-May-170.50100%113763.7%
13Verplas to provide CIM: BOM data setup for all items in 50 ManufacturingNW101 August 201701-Aug-170.20.820%113864.2%
14Data Extract – Bill of MaterialsNW801 August 201710-Aug-171.66.420%814667.9%
15Bill of Materials Import template run throughSB0.501 August 201731-Jul-170.10.420%0.5146.568.1%
16Verplas to provide CIM: Cleansed Static Data Imports in ExcelSB, NW0.507 September 201706-Sep-1700.50%0.514768.4%
17Static Data importSB211 September 201712-Sep-17020%214969.3%
18User Training – Nominal Ledger and Cash BookSB, LC, KR, CK, NW, AR, RF121 September 201721-Sep-17010%115069.8%
19User Training – Stock Control session #1SB, NW, TP, RF, BG, MC125 September 201725-Sep-17010%115170.2%
20User Training – Sales Ledger and Purchase LedgerSB, NW, AR, MD, LC, CK, KR126 September 201726-Sep-17010%115270.7%
21User Training – Stock Control session #2SB, MD, LC, SW, CT127 September 201727-Sep-17010%115371.2%
22User Training – Sales Orders session #1SB, NW, RH, LM, LC, JM0.503 October 201702-Oct-1700.50%115471.6%
23User Training – Sales Orders session #2SB, LW, ZM, MC, RF0.503 October 201702-Oct-1700.50%115572.1%
24User Training – SOP DespatchSB, NW, LC, PW, DA, JC, TP0.504 October 201703-Oct-1700.50%0.5155.572.3%
25User Training – Purchase OrdersSB, LC, RF, NW, MD, PN110 October 201710-Oct-17010%1156.572.8%
26User Training – Bill of MaterialsSB, NW, MD, RF, BG, MP, LC111 October 201711-Oct-17010%1157.573.3%
27User Training – Works Orders session #1SB, NW, EH, GG, BG, CT, MS0.516 October 201715-Oct-1700.50%1.515974.0%
28User Training – Works Orders session #2SB, LC, RF, ME, JE, JM, JE0.517 October 201716-Oct-1700.50%0.5159.574.2%
29User Training – PlanningSB, NW, MD, BG, MP, LC0.517 October 201716-Oct-1700.50%0.516074.4%
30User Training – System AdministrationSB, NW, LC0.518 October 201717-Oct-1700.50%0.5160.574.7%
31User Training – TechnicalSB, NW0.518 October 201717-Oct-1700.50%0.516174.9%
32Test PhaseVerplas4502 October 201703-Dec-170450%4520695.8%
33Verplas to report any queries/issues to CIM post TestingVerplas104 December 201704-Dec-17010%120796.3%
34Pre-Go-Live ConsultancySB, NW, LC111 December 201711-Dec-17010%120896.7%
35Agreement to go live (Before Christmas)SB, NW, LC111 December 201711-Dec-17010%120997.2%
36Go-Live – Import Opening Balances, Client Installs (if applicable)SB, NW, LC120 December 201720-Dec-17010%121097.7%
37Go-Live – Import Opening Balances, Client Installs (if applicable)SB, NW, LC103 January 201803-Jan-18010%121198.1%
38Go Live – HandholdingSB, Verplas104 January 201804-Jan-18010%121298.6%
39Implementation SnaggingNW, LC, SB208 January 201809-Jan-18020%221499.5%
40Business Intelligence Setup and TrainingLC, NW, LM101 February 201801-Feb-18010%1215100.0%

<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>
</tbody>
 

natheplas

Board Regular
Joined
Aug 28, 2016
Messages
89
Here's the data behind the chart, I'm not sure how to paste just images of the gantt chart and data source?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,009
Messages
5,526,258
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top