help logWhen one or multiple control charts are created on a worksheet, they are sized to fit the active window.   Below is an example of an Xbar-R chart.  The two chart fill the active window.

Original Chart

Sometimes you will get a workbook with a control chart from someone else whose active window size when the chart was made is different from yours.  For example, maybe their active window is 75% the size of yours.  The control charts might look like this when you open the workbook.

Smaller charts

You can re-size these charts by doing the following:

1. Select one of the charts

2. Select "Actions" in the "Control Charts" panel on the SPC for Excel ribbon to display the Control Chart Actions form.  

3. Select the "Resize charts to fit screen" option.

4. Select OK on the "Control Chart Actions" form.  The charts are re-sized to fit the window as shown below.

Resize

Notes:

  • Since the software maintains the chart formatting, the points, fonts, etc. on the chart may appear smaller when the control charts are resized.

SPC for Excel

SPC Knowledge Base

subscribe button

Sign up for our FREE monthly publication featuring SPC techniques and other statistical topics.

Customer Stories

Click here to see what our customers say about SPC for Excel!

SPC Around the World

SPC for Excel is used in over 60 countries internationally.  Click here for a list of those countries.

Questions?

Connect with Us