Forum Discussion
Overlap bar chart help
Newbie here & very green :) I'm creating a bar chart with 2 sets of data: start date & end date.
See pix. I created the bar chart, all the bar starts out on the same date!.
I need help here. I need a single bar with start-end dates. A step-by-step lesson would be appreciated very much.
Please help. Thanks!
1 Reply
You want a so-called Gantt chart.
This can be created as a stacked bar chart, with start date as the first series and duration (the number of days) as the second series.
The first series is made transparent, so that only the second series is displayed:
See the attached demo. Click in the chart, then click Select Data on the Chart Design tab of the ribbon to see how the series have been defined.
Microsoft provides several free templates for Gantt charts - select File > New and enter Gantt in the search box.
