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

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.

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it's as easy as creating a table. In earlier versions, you'll need the formula method.

When you have too many data points to display in a dashboard chart, add a scroll bar so users can still view all the data. Sometimes a chart’s underlying data doesn’t fit in the chart window.