The bar chart will visualize your Gantt chart’s most important data points Step 3: Input Duration Data The next step is to add another series to your Excel chart to reflect each task’s duration.

But a hidden benefit is the magic it affords your charts. For instance, add a new column of data to the end of a table, and the linked chart automatically expands to add the new data series. Nice.

Click the sheet tab in Excel for Mac 2011 that contains the chart you need to format. Double-click any bar in the column chart to open the Options panel. Reduce the value in the Gap Width field to ...

The procedure to create a pie chart for data spread across 2 columns only is simple. How to make a Pie Chart in Excel Select the data across the 2 columns in question. Click on Insert > Pie Chart.