Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel+course - charts

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+course - Charts

excel+course - Charts

ResolvedVersion Standard

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

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Convert Text to Columns in Excel 2010

If you have a cell in your Excel spreadsheet that contains a lot of text and you want to divide it into separate columns, this can only be done if there is a logical character which separates the text, for example, a comma.

Select the cells you would like to convert. On the Data tab, click Text to Columns. Choose the format of your current data.

Select Delimited if the text contains a logical character otherwise select Fixed Width if there are a certain number of spaces between each field.

Click Next when a preview of the data appears. Then select the type of character that separates the various fields. If the character is not listed, select Other and enter the character.

Click Next again and then choose the format for each of the columns. Select the column heading in the Data preview and then select a data type from the Column data format options.

Click Finish and the text will appear in several columns.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.