How to Use Microsoft Excel to Draw Control Charts and Graphs. A control chart plots measured values along with upper and lower quality control limits.

Now, let’s insert the data validation control. Using the simple demonstration sheet shown in Figure A, click B2. Feel free to use one of your own files if you like or choose another cell.

Essential Shortcuts Aside from the well-known Excel keyboard shortcuts, these are the ones I use the most often and save me the most time.

Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.