• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

Gantt chart

I have a simple stacked chart and I'd like to change it to a Gantt chart.  The chart shows tasks by hours.  The total hours for all 5 tasks is 240 hours.  

I'd like to spread out the chart so it shows all 240 hours so each new task starts at the end of the previous task.  Does that make sense?

So, the chart would show the full timeline.
first task would go from 0 hours to 48
second task would go from 48 to 96
third task would go from 96 to 168
fourth task would go from 168 to 216
fifth task would go from 216 to 240

Any help would be appreciated.

3 Solutions
Patrick MatthewsCommented:
Please have a look at Sheet2 in the attached file:


Basically, I added a helper column to show the cumulative hours for the previous tasks, and then formatted that data series to show no fill or line in the chart.
TomislavjSystem AdminCommented:

pls see


-Dman100-Author Commented:
Thank you! I appreciate that help.  It is exactly what I needed.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now