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.