Excel doesn't have an option to insert a Gantt chart, meaning you will have to create one using a modified stacked bar chart. Don't worryit's not as hard as it sounds. Prepare Your Data ...

Bar and Column Charts: Ideal for comparing the frequency, count, or volume of different categories. Use vertical columns for time-based data and horizontal bars for comparing different categories.

In this post we show you how to create a Bar Graph or Column Chart in Excel. Bar graphs could be both 2-D or 3-D depending on the editor you use.

How to overlap two series in Excel Overlapping the two series is one way to clear things up a bit. In other words, let’s move the target series so that it’s on top of the actual value series.