Ceri has attended:
Excel Introduction course
Charts
How can you get a chart and its data to fill the whole page when printing it off
RE: charts
Hello NAME,
Hope you enjoyed your Excel training last week.
Simply click on the chart and then press print preview. If you see the whole chart, then print.
Depending on whether a chart is embedded or on a separate chart sheet, you can choose specific print options.
Before you print a worksheet with an embedded chart, you can adjust where the chart will print on the page by sizing and moving it in page break view You can also print an embedded chart without the worksheet data.
Before you print a chart sheet, you can size and scale the chart area, specify how it should be placed on the printed page, and then view it in the preview window.
How to Adjust and Print a Chart Sheet
1.Click the chart sheet that you want to print.
2.On the File menu, click Page Setup.
3.On the Chart tab, under Printed chart size, click Use full page, Scale to fit page, or Custom.
4.If you click Custom, and then click OK, you can drag the chart area to the location and size that you want.
5.On the File menu, click Print.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Richard
Microsoft Office Specialist Trainer