Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.
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.
There are currently no FAQs about Excel 2010: Pivot Tables in Depth.
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.