Excel Tutorial: How to Print Charts in Excel

Printing a chart in Excel and maintaining Worksheet Data

You have two options for printing charts. You can print the chart alongside the worksheet data, or you can print the chart itself. When you choose the latter, the chart is printed in full page version.

Printing a chart in Excel with worksheet data

To print with worksheet data:

1 Select range A1:M29.

2 Choose File > Print.

3 From the Printer Properties menu, select the printer you want to use.

4 In the Scaling box, choose Fit Sheet On One Page; then click Print.

Printing a chart in Excel

To print the chart:

1 Click the Monthly Sales chart to select it.

2 Choose File > Print.

3 From the Printer Properties menu, select the printer you want to use, and then click Print.

4 Choose File > Save to save your work.

5 Choose File > Close to close the worksheet.