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.

Thanks.
UMN-LOE.xlsx
-Dman100-Software ConsultantAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls see

UMN-LOE-V1.xlsx

Regards
0
 
Patrick MatthewsConnect With a Mentor Commented:
Please have a look at Sheet2 in the attached file:

Q-28320324.xlsx

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.
0
 
TomislavjConnect With a Mentor System AdminCommented:
0
 
-Dman100-Software ConsultantAuthor Commented:
Thank you! I appreciate that help.  It is exactly what I needed.
0
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.

All Courses

From novice to tech pro — start learning today.