Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
When you are ready to print a PivotChart, you can use the same skills you have used to print regular charts. In this lesson I will review some of the techniques that you can use to make printing your PivotChart go smoothly. There are two scenarios for printing a PivotChart. The first is if the PivotChart is part of a worksheet and the second is if it's on its own chart sheet. If the PivotChart is part of your worksheet then click the PivotChart and then click the File tab to get to Backstage view and click Print. When you do, the Print page of the Backstage View appears and you will see under Settings that Print Selected Chart is automatically selected and in fact if you click the button, that allows you to select which part of the work we should print.
The only one that's available is Print Selected Chart. So now you can select your printer and click the Print button. But now let's say that the PivotChart is on its own chart sheet. So I will click the Home tab on the Ribbon to move back and then I will shift to the chart sheet named Chart1 and here we see another PivotChart that's on its own sheet. Now if you click the File tab and click Print you will see that have a few more options. For example, if you click the Settings button, you see that you can print the entire workbook and not just the chart.
As you can see in the Print Preview there is a difference between printing a PivotChart on a worksheet and a PivotChart on its own chart sheet. In the first case, the chart prints at the same size at which it's displayed. On a chart sheet the chart takes up the entire sheet and prints as a full page. Printing charts to paper produces copies you can include in annual reports, news releases, and correspondence. You can also choose to print to an Adobe Portable Document Format file or other electronic file format, which enables you to take a copy of the chart with you as you travel, without taking the original workbook from which you printed it.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91242 Viewers
80 Video lessons · 138207 Viewers
59 Video lessons · 57036 Viewers
52 Video lessons · 70676 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.