Forum Discussion

Prabha45's avatar
Prabha45
Helper III
2 years ago
Solved

Bar chart or Gantt chart

 I want to show(Pic 1) sub projects of each project in a single bar over time period like the below image. I tried Gantt chart which shows sub projects over time period, but when I collapse it shows a single project bar without any sub projects on it. So, I moved to Bar chart, I'm able to show (Pic 2)but not able to add dates into x axis. I have the below data. A1 subproject starts only after A2 end date and A3 starts only after A2 end date. Same with project B. Project  on Y axis nd sub projects on x axis and not able to add period.

Thanks in advance.

ProjectSub ProjectStart dateEnd date
Project AA11/1/20221/3/2022
Project AA23/3/20221/4/2022
Project AA32/4/202230/6/2022
Project BB115/3/20225/8/2022
Project BB210/8/202229/10/2022
Need Help
Show and Tell
Tips and Tricks

6 Replies

    • Prabha45's avatar
      Prabha45
      Helper III
      2 years ago

      Thanks Ritaf1983 Gantt chart works partially. but when I collapse sub projects, Projects line shows a single colour( first sub project). I need to show all sub projects in Project line when collapsed. So, I choose Bar chart, but here when I drop date on x-axis it automatically treating as count.

      • Ritaf1983's avatar
        Ritaf1983
        Super User
        2 years ago

        I saw your post about an axis and responded, i am afraid that there is no option to have a Gantt exactly as your pattern.

        If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • Prabha45's avatar
    Prabha45
    Helper III
    2 years ago

    Thank you very much. So, from what I understand Gantt chart can't show all sub projects on Project line when collapsed and Bar charts x axis can't be dates. Is there any way to create like the below image. I don't need individual lines sub projects, just projects having sub projects in it over a period.