Discover how the ampersand operator in Excel can create dynamic formulas, flexible lookups & smarter workflows. Save time and ...

Microsoft Excel 2013 lacks a utility for creating such control charts, but you can manually construct one by properly organizing your data. How to Do the Sum of an Indefinite Series in Excel.

We are going to add a median line to the chart. Enter the formula ... and lower control limit lines with a centerline. READ: How to show Charts with Hidden Data Cells in Excel.