Embedded charts are printed in much the same way that you print worksheets. If you include the embedded chart in the range you want to print, Excel prints the chart as it appears on-screen. It is always a good idea to preview first to be sure that the chart does not span across multiple pages.
If an embedded chart is selected, Excel 2016 for Windows can print the chart on a page by itself and does not print the worksheet. Excel 2016 for Mac will not do this, and will print the worksheet and the chart(s), so care must be taken to adjust placement and size of charts to accommodate page breaks.
Also, if a chart is created on or moved to a separate Chart sheet, then Excel always prints the chart on a page by itself.
Setting Page Options for a Chart
Before printing a chart, you can adjust some page settings. For faster printing, you can change the print quality of the chart to draft quality or black and white printing. You cannot adjust the scaling of a chart or center charts horizontally or vertically on the page; however, if a chart is selected for printing on Windows, it will be centered on the page automatically.
Let's select a chart and set it up to print in landscape.
Step1. To switch to the Page Layout tab,
Click the Page Layout tab
Step2. To select a chart,
Step3. To view the Page Setup settings, in the Page Setup group,
NOTE for MacOS Users: To view the Page Setup settings, on the menu bar, Click File, Click Page Setup... .
Step4. To change the orientation to Landscape, if necessary,
Click the Landscape radio button
Step5. To preview the chart,
NOTE for MacOS Users: To activate Print Preview, on the menu bar, in the File menu, Click Print... , Click, Click Open PDF in Preview. A PDF will be created, and opened in the Preview application.
Step6. Return to the workbook ChartData.xlsx.