Chart the Summary Data Click "Insert" in Excel's ribbon. Click "Pie" in the Charts group, and click one of the "2D Pie Chart" options to create a blank chart. Right-click the chart.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

Create an Organizational Chart With Excel's SmartArt Tool In Excel, you use SmartArt to create a graphic with an organizational chart layout.

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.

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel's Geography data type, creating a map chart is easier than you might think.