Settings for Microsoft Excel Plots

1. Place graph in its own worksheet (Right click on graph → Location → As New Sheet)

2. Go to Page Setup (File → Page Setup)

• Select the Page Tab and click the “Portrait button”
  
• Select the Chart Tab and click “Scale to fit page”
  

3. Change font sizes

• Axis Font: 18 (or larger)
• Label font: 22 (or larger)

4. Line Weight

• Select the heaviest weight for lines (including axis and graph lines or error bar lines). Double Click on the line or points on the graph and under the Patterns Tab → line → weight, select the bottom, heaviest line

5. Point size: 9 (or larger)

6. Remove the graph background

7. When pasting into PowerPoint, do it as “Paste Special” and paste as a picture (enhanced metafile). This will break the link to Excel but reduces the risk of the graph being changed during printing.

Back to Table of Contents