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.

Excel plot box

Back to Table of Contents

Document Actions

Send this