In the Chart Design menu, in the Data group ... Repeat this process for each report sheet you plan to print. Next, hide the sheets you don't want included in the report. To do this, right-click ...