Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

A Microsoft Excel spreadsheet is among the most versatile business tools. Here’s a full guide on how to create a simple and effective Gantt chart in Excel.

In this guide, I'll walk you through the different ways to format your chart, with Excel's main chart-formatting actions written in bold so you can find them more easily.

Click OK. The chart will open on a chart sheet. How to move the chart to a different Excel sheet in the same workbook Before doing this, have more than one worksheet tab open.

When you insert a chart as a picture, it’s a fixed image and will never update or change. (Click for larger image). Linking is a better choice when you don’t intend to send the Word document anywhere.

Figure D The people chart is based on the survey data in the Table. How to customize Excel’s people chart The original settings are adequate, but you might want to customize the chart a bit.

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