The control chart includes upper and lower control limit lines with a centerline. READ: How to show Charts with Hidden Data Cells in Excel.

Click the "Insert" tab, then the "Scatter" icon in the Charts group and select the first "Scatter" option to create the control chart. However, you'll need to reformat the average and limits.

How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

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 tutorial, I’ll show you how to create a burndown chart in Excel and discuss what each line shows in regard to scheduling and meeting deadlines. Download the demo files.

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.

To create a Waterfall Chart in Excel, you first need to have a dataset that includes a starting value, a series of positive and negative changes, and an ending value.

Microsoft recently made some significant enhancements to its Visio add-in for Excel, enabling users to create Visio diagrams from within Excel. Here's how it works.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

We explain how to make a Lollipop Chart in Excel. A Lollipop Chart resembles a Bar Chart but with a line on a point at the end.