+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 16

Gantt chart add multiple start / stop tasks

  1. #1
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    Office 2013
    Posts
    54

    Gantt chart add multiple start / stop tasks

    Hi there,

    I wanna ask if it is possible to make a Gantt Chart but instead of using date as the main line I want to use numbers from 1 to 90 for example. And I want for example to use Task 1 between numbers 1 and 10 and then from 30 to 40. Is that possible? (Multiple tasks would start and end in between the range multiple times)

    Thanks
    Last edited by Martines91; 02-06-2019 at 03:46 AM.

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    1,813

    Re: HELP: Gantt chart

    how is the chart drawn by conditional formatting? if so you would need separate columns for each of your starts and stops for the task. using dates intend of numbers makes no difference the same logic applies

  3. #3
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    Office 2013
    Posts
    54

    Re: HELP: Gantt chart

    I'm not sure if I'm getting you. I can draw a simple explanation in paint if you want, I haven't been doing any Gantt Charts before so that's why I'm asking. If it was regarding date times I could use the ones provided by Microsoft, but I need plain numbers instead of dates.

    gantt.png
    Last edited by Martines91; 01-31-2019 at 09:17 AM.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,844

    Re: HELP: Gantt chart

    Yes, you can do a Gantt chart with numbers. There is nothing special about dates/times in Excel. As far as Excel is concerned, dates and times are just numbers anyway (see this if you are unfamiliar with how Excel works with dates/times: http://www.cpearson.com/Excel/datetime.htm ). Take one of MSFT's examples -> select the horizontal axis -> format -> number as general and you will see that the dates and times are just numbers (probably in the 40000 ballpark). You can use whatever Gantt template or example you are already familiar with and make sure the number formatting is set to general or similar.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    Office 2013
    Posts
    54

    Re: HELP: Gantt chart

    Thanks! I've tried it, and it works as you said, now I only need to figure out how to actually make it repeating, so I won't add the same task twice but just separate it as I showed in the picture above

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,844

    Re: HELP: Gantt chart

    Let us know how we can help. Note that the procedure will probably be different depending on chart type (in cell charting with conditional formatting, stacked bar (older versions of Excel), built in Gantt specialty chart (newer versions of Excel)), so we will need to know exactly how you are trying to build your Gantt chart in order to help.

  7. #7
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    Office 2013
    Posts
    54

    Re: HELP: Gantt chart

    I can prepare it at home or do it at work, at work I have Excel 2013, at home I have 2016. And as I shown above I need it like that, so Task 1 will repeat for example between stages 1 to 6 and then between 14 to 24 and then maybe from 33 to 40, Task 2 from 2 to 7, from 16 to 20 etc. if you get me

  8. #8
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,844

    Re: HELP: Gantt chart

    I'm using 2007, so I cannot use the built in Gantt specialty chart. My inclination would be to use a stacked bar chart. Are you familiar with stacked bar charts?

    This thread has a decent example of a Gantt chart/stacked bar chart with multiple start/stop times. https://www.excelforum.com/excel-cha...cel-chart.html I would expect to do something like this. What would you need help with?

  9. #9
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    Office 2013
    Posts
    54

    HELP: Gantt chart add multiple start / stop tasks

    MrShorty,

    Yes that's exactly what I'm looking for the one file on the bottom of the page. I had a look on it and it's kind of complicated, I will either have to reverse-engineer this and change the format to what I need, or maybe you could help me if you know how to do that quickly. If you download and open the "RLS_Start_Stop_Barchart(pcb).xlsm‎" file then on the Chart_Jul tab you can see what I'm aiming for, but instead of having time on the top axis I would want to have plain numbers from 1 to 90 and on the left axis instead of dates I would want to have specific Tasks, if that makes sense
    Last edited by Martines91; 02-01-2019 at 02:15 AM.

  10. #10
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,844

    Re: Gantt chart add multiple start / stop tasks

    I don't know what progress you have made over the last day or two. Do you have a specific question about the procedure? I would expect:

    1) Data entry into the spreadsheet (Columns B:Y of the Jul17 tab in that file)
    2) Formulas -- if needed -- to compute the "duration" for each stack in the stacked bar. (columns Z:AX of the Jul17 tab in that file). Of course, in your case, "duration" has nothing to do with time, it just means the length of each segment of the stacked bar.
    3) Create and format the chart based on the durations in Z:AX.

  11. #11
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    Office 2013
    Posts
    54

    Re: Gantt chart add multiple start / stop tasks

    Hi,

    Sorry for a late reply. To be honest, none, because the file is actually a bit too complicated for me, I haven't been working with such data before.
    I only proposed that file as what I need, I wouldn't want to work with it since it has way too much of data in there.
    I can provide you what I need but I would need to do it in a new, clean spreadsheet, I can for example prepare a table with the required data,
    being Tasks and Range of Parts, this is going to be separated into 7 sheets.

    I would attach an example file by microsoft how I would like it to look, but unfortunately I cannot open the attachment icon (won't show anything)

  12. #12
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,844

    Re: Gantt chart add multiple start / stop tasks

    The paperclip icon has not worked for some time. To add an attachment, click on "Reply to Thread" or "Go Advanced" to bring up the main post editor. Then scroll down to find the "manage attachments" link which will bring up the file uploader.

  13. #13
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    Office 2013
    Posts
    54

    Re: Gantt chart add multiple start / stop tasks

    Ah, I see thanks, so I've attached 2 files then, Example has the data I need to have on the chart, and the second file is the example provided by microsoft as I want it to look like, thanks for the help
    Attached Files Attached Files

  14. #14
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,844

    Re: Gantt chart add multiple start / stop tasks

    I note that Microsoft's example is using an in cell conditional formatting technique to create a Gantt chart. If you want to, we can pursue using this technique as well.

    However, with what you have in your example, I think a simple stacked bar chart will be easier. Assuming the numbers in your spreadsheet are correct, I:

    1) Select F9:N23 -> Insert -> stacked bar chart. If I like the default formatting scheme, my Gantt chart is finished.
    2) If I don't like the default formatting scheme, I change the format of the various elements to get the look I want. For example, I probably want the "starting part no." data series to be formatted as "invisible" (no fill no border), so I select each of those data series and change the formatting as desired.

    Your file did not include any of your attempts to create this chart, so I'm not certain if you tried that or what difficulty you had creating the chart. That's what I would do next. Is that helpful?

  15. #15
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    Office 2013
    Posts
    54

    Re: Gantt chart add multiple start / stop tasks

    Sorry, I don't have much time to do this at work to be honest (busy most of the time) but now I've tried it and yeah, it's exactly what I wanted, I just need to format it to the way I like, thank you for the tip

    Edit: It's not working properly, for the first Starting Part No. and Duration, it's ok but afterwards the numbers add up. So instead of Task 1 having start part no. 7 and duration 5, it starts at 14 but duration is ok
    Last edited by Martines91; 02-06-2019 at 03:46 AM.

+ Reply to Thread
Page 1 of 2 1 2 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1