To get your chart to fill the entire page in Excel 2007, you can follow these steps:
- Click on the chart to select it.
- Go to the "Page Layout" tab in the ribbon.
- Click on the "Print Area" dropdown and select "Set Print Area".
- Go to the "Size" dropdown and select "More Paper Sizes".
- In the "Page Setup" dialog box, select the "Page" tab.
- Under "Scaling", select "Fit to:" and set both the "Width" and "Height" to "1 page".
- Click "OK" to close the dialog box.
- Go back to the "Page Layout" tab and click on the "Print Titles" dropdown.
- In the "Page Setup" dialog box, select the "Sheet" tab.
- Under "Print Titles", click on the "Rows to repeat at top" field and select the row(s) that contain your chart title and axis labels.
- Click "OK" to close the dialog box.
Your chart should now fill the entire page when you print it. If there are still gaps between the chart and the top/bottom margins, you may need to adjust the margins or the size of the chart.