By selecting all three columns of data, you can select the type of chart from Excel's Insert tab. The most useful selection is a bar chart, because it allows you to format the second series as a line.

Make sure each row is beside the corresponding bar in the Gantt chart. Repeat Steps 1 through 4 as needed. Alternatively, you can change the size of the Gantt chart by dragging any corner.

Example of a 3D Bar Chart from Excel Excel’s three-dimensional bar charts are common. Often, the bars in the front obscure those in the back, as happens here.

Click on the type of bar graph you want. The graph menu will disappear as your graph is now part of your document. 7. To change the title of your graph, click on "Chart Title" at the top of the chart.